View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hitesh hitesh is offline
external usenet poster
 
Posts: 70
Default vlookup for different ranges

hi

i have different database in different sheets i.e sheet1, sheet2, sheet3,
sheet4, sheet5...............sheet10,

in sheet 11 i used vlookup formula, i wnat to use the vlokup range for all
the sheet, if the value is not find in sheet 1 than find in sheet 2 or in
sheet 3 or in sheet4 means upto sheet 10 .

vlookup is possible for all the above sheet, is it possible.

helps needs

regards