Vlookup - Link external filename to a cell and apply to formula?

[Triniboy]

Hi Everybody! I had a hard time figuring out what to title this post, so bear with me while I explain what I need to do. I work in an office where we receive large spreadsheets of data on a monthly basis. Creating the Vlookup formula for the information I needed was easy enough, but what I want to do is to be able to type a file path and array information into a cell and link that cell to the table array section of the Vlookup function.

For Example:

Cell F5 will have: 'C:\Users\JohnSmith\Desktop\[January.xlsx]Sheet1'!$A$2:$H$14

Then instead of placing that whole string into the Table Array section of the Vlookup function, I want to just source cell F5

So it would look something like: =VLOOKUP(B11,F5, 5, FALSE) <--- but of course that doesn't work :-(

Is there a way to make this work?

[ConneXionLost]

Untested, but try something like this:

Please Login or Register  to view this content.

Good luck!

[Tony Valko]

Just be aware that the source file will have to be open for the INDIRECT function to work properly.

No good solution for this.