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.