Ask Your Question

Create dynamic file reference

asked 2016-07-18 12:42:55 +0200

Bernmeister gravatar image

(originally posted on StackOverflow)

Is is possible to create a file link using the value from another cell? For example, if I ultimately want a file link


(which pulls in data from another file/sheet/cell), but instead of typing out the whole thing (because I have lots of entries) I instead have a formula which would function as


where cell A2 contains the value AAA.

Thanks in advance,


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-07-18 17:31:13 +0200

m.a.riosv gravatar image


Be aware that INDIRECT() is a volatile function using it extensively can make a bit slower the spreadsheet.

edit flag offensive delete link more


Thanks! Have started rolling into my spreadsheet - noticed it is slightly slower but that's fine given the time saved for me when I have to continually edit.

Bernmeister gravatar imageBernmeister ( 2016-07-19 00:03:47 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-07-18 12:42:55 +0200

Seen: 74 times

Last updated: Jul 18 '16