Compare two lists?

  • Thread starter Thread starter s_tyrone
  • Start date Start date
S

s_tyrone

Hi,

Very simple question, I have two lists of people with one much longe
than the other.

I want to compare the lists and have an indicater to find out whic
names from the smaller list shows up on the larger list.

thanks so much
 
In the adjacent column,

=IF(ISNA(MATCH(A1,$B$1:$B$20,0)),"",MATCH(A1,$B$1:$B$20,0)), where A1
is the name to look up and B1:B20 contains the list of names to match.
 

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

Compare multiple cells and highlight differences 5
Excel Comparing two columns 1
Excel. How do I remove 1,000 mailed addresses from list of 2,265? 6
Comparing 2 lists to display only records in 1 but not in both lis 1
Comparing two lists 3
How to filter list from pre-existing list 1
compare two columns and pull out differences 1
Comparing 2 spreadsheets to remove duplicate names 2

Back
Top