Excel - Vlookup

[shraddha]

Is there a way to use 3-D reference in the vlookup
function? I'm trying to have the vlookup function look in
multiple sheets for a specific data.

I would appreciate any help.

Shraddha

 

[Peo Sjoblom]

Something like

=IF(ISNUMBER(MATCH(A1,Sheet2!A2:A100,0)),VLOOKUP(A1,Sheet2!A2:B100,2,0),IF(I
SNUMBER(MATCH(A1,Sheet3!A2:A100,0)),VLOOKUP(A1,Sheet3!A2:B100,2,0),IF(Isnumb
er and so on

of course you will soon run into the 7 nest limit if you have many sheets.
In that case you might want to download morefunc from Laurent Longre

http://longre.free.fr/english/

it has a function called threed that will return a 3D range into a single
array, then you could use vlookup
for that array