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.
|