Compare two lists?

[s_tyrone]

Hi,

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

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

thanks so much.

[Vito]

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.