Apply the formula in C1 which will check the value of B1 in A and return Y or N

=IF(COUNTIF(A:A,B1)0,"Y","N")
--
If this post helps click Yes
---------------
Jacob Skaria


"JoeM" wrote:

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.