Excel - Vlookup

  • Thread starter Thread starter shraddha
  • Start date Start date
S

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
 
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
 
Back
Top