vlookup from more than 1 sheet.

  • Thread starter Thread starter shital
  • Start date Start date
S

shital

i am useing vlookup function where
i want to view data range soure from sheet1,sheet2 & sheet3

it should search from sheet1,2 & 3 than give the value.

shital
 
Maybe there's a way, but I don't think you can use VLOOKUP on more than one
sheet at a time,......if you don't get a better answer, you might try
stacking VLOOKUP formulas in a big IF formula, or, maybe copy all three
ranges to a fourth sheet NamedRange and do the VLOOKUP there.......

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top