Index Cell information based on another workbook

[billyshears]

Cell A1 = name of a different file (G:\workbooks\sheet.xlsx)


I want to pull information from a cell in that file to into Cell C1.

Is there a way to do that without directly linking the files so its based on formula? I thought INDEX would work but I cant seem to figure it out.

Thanks in advance

 

[Mark80]

Hi,

You need to use the INDIRECT formula. Something like this should work:

=INDIRECT("'["&A1&"]Sheet1'!$C$1")

 

[billyshears]

That didn't work.

 

[billyshears]

Apparently the issue is that INDIRECT needs the file to be open at all times. I need it to work with the file closed