vlookup from more than 1 sheet.

[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

 

[CLR]

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