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.