Vlookup, using a cell that contains the table reference

[AdamParker]

Hello,

Thanks for taking your time at looking at this post.

I have a worksheet that uses a lot of vlookups and I have to update the filenames and locations quite often. I would like to update a single cell rather than updating every single formula.

However I am getting the #VALUE error when trying this.

Simplified Example:
I have: =VLOOKUP(A3,[Table.xls]Sheet1!$A$1:$B$4,2,FALSE)
I would like to place [Table.xls]Sheet1!$A$1:$B$4 into a cell (D1) for example.

And have my vlookup function as =VLOOKUP(A3,$D$1,2,FALSE)
This way I only have to update D1 when I want to change the filename instead of a whole lot of functions.

Any help would be appreciated, Thanks!!

Adam

[JBeaucaire]

You want the INDIRECT function.

Please Login or Register  to view this content.

[JBeaucaire]

Duplicate. Sorry.

[joinashish]

Did u able to get answer to your thread...I am struggling for the same thing. Your help would be appreciated.

[JBeaucaire]

Yes, the indirect() solution was given in post #2. If you cannot adapt that (read up INDIRECT() in the Excel F1 Help files), then start a thread of your own and provide a sample workbook so someone can help you directly. Thanks.