IF formula with multiple conditions

**jomili** · 09-12-2011, 04:18 PM

Sorry, but I'm getting myself confused on an if formula, and hope I can get some help with it.

Here's what I'm trying to do:

1) IF AL2 contains something, put a blank
2) else, if AL2 is blank, and IF AH2 AND AI2 are both blank, put a blank.
3) However, if AL2 doesn't contain anything, and IF AH2 has something, put the results of the first Vlookup
4) IF AH2 has nothing, and If AI2 has something, put the results of the second Vlookup.

Below is my attempt so far, without even attempting the first condition. Any help on this is greatly appreciated.

Please Login or Register  to view this content.

**NBVC** · 09-12-2011, 04:30 PM

Does this work?

Please Login or Register  to view this content.

**jomili** · 09-12-2011, 04:41 PM

Almost. IF AL is blank, and AH and AI are blank, it's putting nothing.
IF AL is blank, AH has a value, it's putting the result of the vlookup.
However, if AL is blank, and AH is blank, yet AI has a value, it's not putting the result of the vlookup using AI.

**jomili** · 09-12-2011, 04:44 PM

I found it. You had AL in one spot instead of AI. I fixed it, and the formula works great. Here's the final formula:

Please Login or Register  to view this content.

**NBVC** · 09-12-2011, 04:44 PM

That second reference in the AND should have been to AI2, not AL2...

Please Login or Register  to view this content.

**jomili** · 09-12-2011, 04:50 PM

Thanks NBVC. I appreciate your followthrough on this one. That's a pretty nifty IF formula; I'm learning how to do them, but this one was way over my head. Thanks for straightening me out.