Daniellovesxl
New Member
- Joined
- Jul 30, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello all, I have a workbook that uses many vlookups to multiple tables in one separate workbook. I am fine with having to have the separate workbook open at the same time.
I have successfully used the vlookup function to pull the correct value but I would like to write vlookup formulas that refer to a cell containing the external workbook name and include for each formula, an indirect reference to the workbook name and include the applicable table name. The nature of the workbook that contains the tables is that the table data changes from year to year and I would like to copy and rename the table-containing workbook and just change the indirect file name. This would make it easier to write formulas (not having to re-write formulas just to update the workbook name.
I have successfully used the vlookup function to pull the correct value but I would like to write vlookup formulas that refer to a cell containing the external workbook name and include for each formula, an indirect reference to the workbook name and include the applicable table name. The nature of the workbook that contains the tables is that the table data changes from year to year and I would like to copy and rename the table-containing workbook and just change the indirect file name. This would make it easier to write formulas (not having to re-write formulas just to update the workbook name.