Vlookup Multiple Ranges

[John]

Does anyone know if it is possible to look up a value in
multiple ranges? For instance, say there is a value in
cell L7. I want to look up that value in L1:L6 and
L8:L100. I tried entering the following formula, =VLOOKUP
(L7,(L$2:L6,L8:L$100),1,FALSE), but I get an error.

Thanks for any help.

John

 

[Dan E]

John,

Since Vlookup will find the first exact match you could use
as an if statement

=IF(ISERROR(VLOOKUP(L7,L$2:L6,1,FALSE)),VLOOKUP(L7,L8:L$100,1,FALSE),VLOOKUP(L7,L$2:L6,1,FALSE))

Then if no match is found in L2:L6 it will look in L8:L100.

Dan E