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!