Nested IF(ISNA(Vlookup or ?

[stapuff]

I read a post that doing multiple Vlookup's is not a very efficient way to find a value in multiple places.


B2 is where I want the result of up to 3 different ranges

This is not written correctly. I just wanted to illustrate the ranges.
Vlookup,A2,F2:G200,2,False
Vlookup,A2,M2:O250,2,False
Vlookup,A2,X2:Z150,3,False

I have been able to get a double lookup to work but not a third.

What is a better way to do multiple range lookups or how could I add the 3 Vlookup.

At home right now so I can't post the IF(ISNA(VLOOKUP statement that I already have.

Thanks,


Kurt

 

[stapuff]

Yogi -

I must bow down to the MVP. Completely outstanding. I agree things can become extremely difficult when adding to a formula like this. I intend not to.

Thank You for your time, energy, and results.

Kurt