Prev: Formula Help
Next: Time Format Question
From: Ms-Exl-Learner on 12 May 2010 12:25
Correction to my previous post.

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

--------------------
(Ms-Exl-Learner)
--------------------


"Ms-Exl-Learner" wrote:

> Copy and paste the below formula in B2 cell.
> =IF(A2="","",IF(ISNUMBER(COUNTIF(D:D,A2)),"Y","N"))
>
> Remember to Click Yes, if this post helps!
>
> --------------------
> (Ms-Exl-Learner)
> --------------------
>
>
> "daisy" wrote:
>
> > 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!!!!
First  |  Prev  | 
Pages: 1 2
Prev: Formula Help
Next: Time Format Question