=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)

"Donald B" wrote in message
...
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