How do I match number IDs from 2 worksheets - when one worksheet is only a subset of ids from the other?
April 17, 2012 5:58 AM Subscribe
Excel help: How do I match number IDs from 2 worksheets - when one worksheet is only a subset of ids from the other?
posted by quodlibet to Technology (6 answers total) 1 user marked this as a favorite
I have two worksheets that have a common # id. Worksheet A includes the entire population of cases and includes all the # ids. Worksheet B includes only a subset of cases and includes only those # ids. (A is a list of all cities, B is a list of only certain cities - the # id is the Census #, if relevant). Worksheet A has additional information that I want to merge with B - but I only want those with # ids on B. How do I match up the #s?