Check data from existing list

Hi,

I need a formula to check if anyone from the Old employee col(B) exist in current employee column(A).

A B
Current employees Old employees
A C
B G
C T
D
E
F
G

Thanks.

And how do you want it reported? You could have this formula in C2:

=IF(ISNA(MATCH(B2,A:A,0)),"No","Yes")

then copy down to the bottom of the list of old employees.

Hope this helps.

Pete

This is working fine..many thanks Pete