| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VLOOKUP with a reference to a different file...
Hello.
I'm using VLOOKUP to grab data from a different file... that part is pretty simple. The problem is the file name gets changed a lot. I need to have one cell that has the path, and somehow get VLOOKUP to reference it's table_array portion to that cell's path. that way instead of changing the 532 formulas everytime someone changes the file name I can just change that one cell. I'm having trouble getting this to work, I think the problem is with telling it to look at the first tab but i'm not entirely sure. please help!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking to another file using file reference typed cell | Excel Worksheet Functions | |||
| cross-reference data from one file to another file | Excel Discussion (Misc queries) | |||
| VLOOKUP Reference Help | Excel Discussion (Misc queries) | |||
| How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
| copy/paste from one file to another without file name reference | Excel Discussion (Misc queries) | |||
Threaded Mode
