Compare two lists?
 

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.


--
s_tyrone
------------------------------------------------------------------------
s_tyrone's Profile: http://www.excelforum.com/member.php...o&userid=27510
View this thread: http://www.excelforum.com/showthread...hreadid=489418

Compare two lists?
 

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.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489418