Assuming Header row in A1:C1
and your data in A2:A1000 and
B2:B1000
In Cell C2 enter =(COUNTIF($B$2:$B$1000,A2))
and copy down to C1000

0 = Name in Col A not in Col B
1 = Name in Col A IS in Col B




"jbressma" wrote:

So I have two lists in Excel of about 1500 clients names. I am basically
trying to find out if any of the client names in Column A also appear in
Column B. Is there any way for Excel to do this for me? Thanks!