Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple reference
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with multiple reference
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference - Vlookup | Excel Discussion (Misc queries) | |||
Vlookup with Multiple like values in the reference column | Excel Worksheet Functions | |||
How do I vlookup multiple rows with same reference? | Excel Worksheet Functions | |||
Vlookup reference the row below | Excel Worksheet Functions | |||
VLOOKUP Reference Help | Excel Discussion (Misc queries) |