Variable Link in Excel

Question

Good Morning,

I want to ask you all, if anyone knows if it is possible to create a link to another Excel file through a formula so that you can change the name of the file in another referenece cell and with that, all the cells automatically will use the referenced link.

For example, assuming we have 3 files named Ref1.xlsx, Ref2.xlsx, and Formulas.xlsx. In the Formulas.xlsx file we enter in the cell A1 the name of the first file (Ref1.xlsx) and in the cell B1, we insert a formula that searches for the cell B1 value of the file contained in cell A1 (Ref1. xlsx). In this case, the value returned by the formula from cell B1 would be the value of cell B1 of the Ref1.xlsx file. If we change the value from the cell A1 to Ref2.xlsx, the formula from the cell B1 would return the value of cell B1 from file Ref2.xlsx.

Could be this possible?

Answer 1

You can use INDIRECT.EXT, which is part of the MoreFunc add-in.

Answer 2

Hi, Smitty,

Thank you by your tip, but I got a way to create a formula with INDIRECT standard function that have worked properly.

Tks,

Osvaldo