How do I compare two columns where 1 is used to find errors in the 2nd

[RaymondC]

Thanks Frank

It was round about, but it works

Thanks agai

 

[graphguy]

Col A Col B Col C

2000list RESULT 50list
Jon Jones no Jon Jones Joe Jones
Joe Adame no Joe Adame John
Joe Jones yes
John yes


=IF(ISNA(VLOOKUP(A2,ref,1,FALSE)),"no "& A2,"yes")


I think this is what you are asking