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.