View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
hitesh hitesh is offline
external usenet poster
 
Posts: 70
Default vlookup more than one range

hi
mike
for vlookup. if range is more than 2, what changes have to make in formula,
and also mike i want to know about sum formula like v lookup more than 2
range.

regards
anil u


"Mike H" wrote:

one way


=IF(ISNA(VLOOKUP(D1,Sheet1!A1:B11,2,FALSE)),VLOOKU P(D1,Sheet2!A1:B11,2,FALSE),VLOOKUP(D1,Sheet1!A1:B 11,2,FALSE))


Mike


"SSJ" wrote:

Hello All,

Can VLOOKUP lookup in two different different ranges residing in separate
worksheettabs? In other words, if a match is not found in the first range
then lookup the 2nd range.

Can someone help in constructing such formula?

Regards
SJ