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

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.

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(I SBLANK(A4),IF(ISBLANK(A5),"",your_lookup_formula_f or_A5),your_lookup_formula_for_A4),your_lookup_for mula_for_A3),your_lookup_formula_for_A2),your_look up_formula_for_A1)

Cheers
JulieD


"Jim" wrote in message
...
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.

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



"Jim" wrote in message
...
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.

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)

--
Regards
Frank Kabel
Frankfurt, Germany

"Jim" schrieb im Newsbeitrag
...
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.