Hi,
if your master list in is A1:A100
and your dealt with list is in B1 downwards

in C1
=IF(COUNTIF($A$1:$A$100,B1)0,"dealt with","to see")

Drag this down for all the data in column A.

This may look messy because the "dealt with" and "to see" in column C
will be for column A values. If you can, insert a column between A and
B and then put this in B1

=IF(COUNTIF($A$1:$A$100,C1)0,"dealt with","to see")

drag down for all values in column A and now the response lines up with
the data in column A.

When you say it doesn't work, if this doesn't come back and tell us
what you are getting.


HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=386281