FINDING CELL WITH NO TEXT

[billheath]

=IF((A12 ISBLANK = FALSE),(VLOOKUP($A12,$I$13:$S$120,5))," ")

I am trying to use the above formula in an excel cell. I need to look up a value when there is text in the mentioned cell(A12 in this case). I keep getting the #Name? answer. The formulae =IF VLOOKUP($A12,$I$13:$S$120,5)works. However when I add the text is when I get the error.

Thanks for your help!
Bill

 

[randy700]

How about this:

=IF((A12&""=""),(VLOOKUP($A12,$I$13:$S$120,5))," ")

Randy

 

[randy700]

Or this:

=IF(ISBLANK(A12),(VLOOKUP($A12,$I$13:$S$120,5))," ")

Randy

 

[SkipVought]

Your ISBLANK() syntax is incorrect

ISBLANK(A12)=FALSE

But Randy's method is preferable.