Try this...

=IF(COUNTIF(Sheet2!A1:A69,A1),"No","Yes")

--
Biff
Microsoft Excel MVP


"sross002" wrote in message
...
I have a list of names on sheet2 (a1:a69) and if the name in cell a1
(sheet1)
matches any of those names then I want it to say "NO" in cell a2 (sheet1).
if it doesn't match then I want it to say "YES" in cell a2 (sheet1).

I'm assuming it is a combination of a "vlookup" and a "if" formula, but I
can't right it out. Please help.