try
=indirect("[C\Files"&d2&"\"&E2&F2&"]"&"Sheet1!A1")

"DJ Pomeroy" wrote:

Okay, this is what I'm trying to do.

I would like to create a log that would track changes from other files. This
log file would know the file names based on other information in the log. I
would like to do it this way so I won't have to change every line of the
log. Is there a way to place a type of "=d2" formula when looking into
another file?

For example, For Cell A2, I want it to get the file from:

C:\Files\Subfolder\FileName.xls

"Subfolder" will be whatever is listed in cell D2
"File Name" will actually be what is listed in cell E2 + cell F2
And then inside that file, I'll want it to come back with Cell A1 (or
whatever).

Is this possible?