Hi,
assuming list A is in A1:A1000 on sheet 1
list B is in A1:A1000 on sheet 2
in B1 on sheet 1 put this formula
=IF(COUNTIF(Sheet2!$A$1:$A$1000,A1)0,"match","no match")
HTH.
--
greg7468
------------------------------------------------------------------------
greg7468's Profile:
http://www.excelforum.com/member.php...fo&userid=9031
View this thread:
http://www.excelforum.com/showthread...hreadid=386077