Ask Your Question
0

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

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

simeva gravatar image

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

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)?

Thanks!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

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

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

Stats

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

Seen: 29 times

Last updated: Feb 01