Here's one way...

=IF(COUNTIF(D$2:D$1631,A2),"Y","N")

--
Biff
Microsoft Excel MVP


"daisy" wrote in message
...
Hi, can anyone help me write an IF statement? I have a list of names in
Column A and want to check it against another list of names in Column D -
if
the name matches one of the names in Column D I'd like it to put a Y in
Column B. I tried
=IF(A2,VLOOKUP($D$2:$D$1631,"Y","N")) but it doesn't work.
--
Thank you in advance!!!!