Vlookup with multiple reference

[Yanky]

VLOOKUP("your_criteria",THREED(Sheet1:Sheet40!A1:B100),2,0)
This formula is not working
finaly I got it #Name? this ans.
pls help us?

 

[Pete_UK]

Well, THREED is not a native Excel function, so you must ensure that
the add-in which supports this function has been installed.

Hope this helps.

Pete