Belleke Well-Known Member Feb 25, 2019 #1 Hi, I want to replace test in this formula with the value in List!B3 Code: C:\Users\Belle\Documents\chandoo\test\[Data.xlsx]Sheet1'!A1 I tried a few things like indirect but it give me errors. Thanks
Hi, I want to replace test in this formula with the value in List!B3 Code: C:\Users\Belle\Documents\chandoo\test\[Data.xlsx]Sheet1'!A1 I tried a few things like indirect but it give me errors. Thanks
Khalid NGO Excel Ninja Feb 25, 2019 #2 Hi, INDIRECT function doesn't work with closed files. Regards,