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

On Dec 11, 12:09*pm, Yanky wrote:
VLOOKUP("your_criteria",THREED(Sheet1:Sheet40!A1:B 100),2,0)
This formula is not working
finaly I got it #Name? this ans.
pls help us?