Vlookup Multiple Ranges

  • Thread starter Thread starter John
  • Start date Start date
J

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