One way...

Comparing column B to column A with the list in column A in the range
A1:A20.

=IF(COUNTIF(A$1:A$20,B1),"match","")

Copy down as needed.

--
Biff
Microsoft Excel MVP


"JoeM" wrote in message
...
I have a number of ids in two columns and am trying to represent which ones
in the second column also appear in the first.