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
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