Forum Discussion

Brass Contributor

Jan 31, 2022

Solved

help with INDIRECT formula

I used the indirect formula in the column TARGET (G5) to have a full path with file name, file extension, work sheet and a specific cell i need the value from, but it doesn't give me any result. it ...

excel

Formulas and Functions

SergeiBaklan
Jan 31, 2022
olopa67

It looks like duplication of https://techcommunity.microsoft.com/t5/excel/how-to-get-data-from-a-file-if-i-select-the-file-name-from-a/m-p/3092165/highlight/false#M132143

HansVogelaar

MVP

Jan 31, 2022

olopa67

There are several problems with the formula, but it doesn't really matter. The INDIRECT function only works with references to another workbook if that workbook is open in Excel. If the other workbook is closed, INDIRECT will return #REF!

I'd import the sheets you need into the current workbook.