IF formula help?

[daisy]

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.

 

[Glenn]

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.

Try looking in the help file for the proper format for the IF and VLOOKUP
functions...


IF( logical_test , value_if_true , value_if_false )


VLOOKUP( lookup_value , table_array , col_index_num , range_lookup )


I think this will work for your needs:

=IF(ISERROR(VLOOKUP(A2,$D$2:$D$1631,1,FALSE)),"N","Y")

 

[T. Valko]

Here's one way...

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

 

[Ms-Exl-Learner]

Copy and paste the below formula in B2 cell.
=IF(A2="","",IF(ISNUMBER(COUNTIF(D,A2)),"Y","N"))

Remember to Click Yes, if this post helps!

 

[daisy]

thanks everyone -

 

[Ms-Exl-Learner]

Correction to my previous post.

=IF(A2="","",IF(COUNTIF(D,A2)>0,"Y","N"))