Use a cell's value to set the source file name in link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a formula that will link to another file, where the
name of the file (or part of the name) is provided in another cell.

For example, instead of the formula:

='[File Name.xls]Sheet Name'!$C$5

I want to be able to enter:

='[D8]Sheet Name'!$C$5

Where cell D8 in the local worksheet contains the file name. The above
syntax does not work, and I've tried a number of other logical guesses, but
none of them work.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update cell value based on name and specific date 1
Drop Down with dynamic named range offsheet source list 14
replacing just the sheet names within formulas 1
VLOOKUP with a Named Range argument 1
Defined names 3
Use named ranges in array formula 14
Linked Named Ranges 2
Vlookup and return sheet name also 2

Back
Top