Cross-Referencing Lists

J

jhayes

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

Is it possible to cross-reference 2 separate lists in Excel. For example: If I have one list of registered voters (names, addresses) and a second list of fishing permit holders (names, addresses), can I cross-reference those lists to find out which names and or addresses are common to both lists? (The ultimate result = voters in fishing permit households). I'd like to target certain demographics from a litany of existing databases. Is this possible?
 
S

Shane Devenshire

Hi,

If you show us your data layout we could give you a detailed solution. For
example, Name and Address - in one column, or 2, 3, 4, or maybe 5 columns >
Street, City, State, Country, Zip. First and Last names in one column, with
the addresses, or each in their own column?

The general approach is to use VLOOKUP or MATCH. Address or Name matches
are notoriouosly dangerous because of the chance for misspellings.
 
S

Shane Devenshire

Hi again,

Also depending on your data layout you might be able to use COUNTIF or if
you are using 2008 COUNTIFS. And finally there is SUMPRODUCT.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

function to randomly insert text from a given list 2
HELP MATCHING PHONE NUMBERS ON VOTER LIST [combining lists from different sources] 4
Can Exel cross reference 7
how to sort the rows based on data in one column 3
How do I remove duplicated data over an entire spreadsheet? 1
Compare lists on different worksheets to identify overlap 1
How to make Mailing Labels from a Worksheet? 3
Cross Referencing 3 Lists 8

Top