Ask Your Question

[solved] How do I get a function to treat the content of a cell as range name?

asked 2019-02-01 13:49:11 +0100

simeva gravatar image

updated 2019-02-01 14:23:44 +0100

Say Cell A1 of a spreadsheet contains the text string 'Name1', and Name1 is the name of Cell D9, that contains the value 100. What function can I enter in Cell B1 that only references Cell A1, and outputs the value (100) in the named cell (D9)?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-01 14:21:01 +0100

simeva gravatar image

Ha! I found the answer. The function INDIRECT does this.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-01 13:49:11 +0100

Seen: 60 times

Last updated: Feb 01 '19