IF Function, Further Complexities (more newbie help)

[Chris Olson]

Using the following formula:

IF(COUNTIF(B$1:B$45,A1)=1,"Yes","No")

I have been able to populate my cells with the appropriate "yes" or "no".

Is there a way now to say if the value (A1) has been found at B:45, to then
have it check D:45 and input the text that is in D:45 into the formula
result as well, or perhaps in a standalone formula.

For instance, if D:45 were the text of a date, the formula would display:
"Yes, 12/29/2003"

 

[Guest]

solution:

if(countif(B$1:B$45,A1)=1,concatenate("Yes",text
(d45,"MM/DD/YYYY"),"No")

 

[J.E. McGimpsey]

One way:

=IF(COUNTIF(B$1:B$45,A1)=1,"Yes, " & VLOOKUP(A1, $B$1:$D$45, 3,
FALSE), "No")