Hi,
assuming your first list is in A1:A100
and your second list is in B1:B100
in C1 put this formula
=IF(COUNTIF($A$1:$A$100,B1)0,"match","")
drag this down column C
HTH
--
greg7468
------------------------------------------------------------------------
greg7468's Profile:
http://www.excelforum.com/member.php...fo&userid=9031
View this thread:
http://www.excelforum.com/showthread...hreadid=381236