Forum Discussion
Help with XLOOKUP
If the other workbook will be open in Excel too, you can enter its file name in D2 (in the form May 2025 Metrics.xlsx), and change the formula to
=XLOOKUP([@Name], INDIRECT("'["&D2&"]Individual Tech Summary'!$A:$A"), INDIRECT("'["&D2&"]Individual Tech Summary'!$D:$D"))
Good to hear it worked for you.
It doesn't really matter whether the workbook referred to is in the same folder as the workbook with the formula or not. INDIRECT only works if the other workbook is open in Excel; if that workbook is closed, INDIRECT will return #REF!
I tested this an you are correct all I am getting is the #REF, is there any way to make this work if the other file is not open? I will be ref about 6 -8 files to populate this spreadsheet. Again thank you for your assistance with this.