Forum Discussion

rhowell's avatar
rhowell
Copper Contributor
Jun 05, 2025
Solved

Help with XLOOKUP

=XLOOKUP([@Name],'[May 2025 Metrics.xlsx]Individual Tech Summary'!$A:$A,'[May 2025 Metrics.xlsx]Individual Tech Summary'!$D:$D) Let me say thanks in advance for any help with this. I have to pu...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jun 06, 2025

    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"))

HansVogelaar's avatar
HansVogelaar
MVP
Jun 06, 2025

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"))

Resources