| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup dynamic pathname
Hello,
I need a vlookup pathname to be found in a cell. Is this possible? for instance: =vlookup(a2, " value found in another cell " , 2,false). The folder, tab, cells are always the same. The only varience is the workbook name. I've looked on forums to try and help they all suggest other addins. I'm not too keen to install them as it is a work computer. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup dynamic pathname
Use INDIRECT function
It basically lets you use it in VLOOKUP to point to a cell which can have a formula to generate the filename... "mdhodgson" wrote: Hello, I need a vlookup pathname to be found in a cell. Is this possible? for instance: =vlookup(a2, " value found in another cell " , 2,false). The folder, tab, cells are always the same. The only varience is the workbook name. I've looked on forums to try and help they all suggest other addins. I'm not too keen to install them as it is a work computer. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display the pathname/address of a hyperlink? | Excel Worksheet Functions | |||
| How do use listed pathname to link values from another workbook? | Excel Discussion (Misc queries) | |||
| Using a dynamic pathname in VLOOKUP | Excel Worksheet Functions | |||
| Using a variable to represent the pathname in a formula | Excel Discussion (Misc queries) | |||
| Full Pathname in Titlebar | Setting up and Configuration of Excel | |||
Hybrid Mode
