Hi,

i've been struggling to find a simple or effective formula for the below:

i have a list of names and i want to confirm, (yes or no), if each name is found in a second list of names.

=IF(ISNA(VLOOKUP(A1,RANGE,2,FALSE)),"no",VLOOKUP(A1,RANGE,2,FALSE))

this worked okay however it didn't give me the 'yes' text if it was correct, instead it just copied the name

is there a simpler way? e.g. COUNTIF


thanks!