Match with yes or no question

[Guest]

Hi All - I've looked all over for the answer to this question but. ..

I have a list of names that appear multiple times that I need to match with
a "YES".

This list also contains names I want to ignore. l would like to put a "yes"
on the ones I want to keep (no matter how many times it aappears) and "no" on
the ones to ignore.
TIA -- Donald

 

[Bob Phillips]

=IF(ISNUMBER(MATCH(A2,CompareToList,0)),"yes","no")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)