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

[simeva]

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!

[simeva]

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