Is there a function for "not isblank" (find a cell that has a val.

[Jim]

I am searching across 5 cells.
One of the 5 will have a value in it.
Depending upon which cell has a value on it I will preform a lookup.
If the value isblank I do not want to perform the lookup.

How can I have multiple nested if statements while using the lookup.

 

[JulieD]

Hi Jim

if the lookup is depended on which cell has the value in it then you need to
check each cell
e.g.
=IF(ISBLANK(A1),IF(ISBLANK(A2),IF(ISBLANK(A3),IF(ISBLANK(A4),IF(ISBLANK(A5),"",your_lookup_formula_for_A5),your_lookup_formula_for_A4),your_lookup_formula_for_A3),your_lookup_formula_for_A2),your_lookup_formula_for_A1)

Cheers
JulieD

 

[CLR]

Hi Jim.........

If you are sure there will only be a value in one of the cells, you can name
the range of those cells "RANGE1" or whatever, and your VLOOKUP table
"Range2" or whatever,
and use this formula.........

=VLOOKUP(SUM(range1),range2,2,FALSE)

Vaya con Dios,
Chuck, CABGx3

 

[Frank Kabel]

Hi
if you could explain which lookups you want to do depending on what
cells there may be an easier solution. Could you state exactly your
conditions and lookup requirements (with exact cell references)