Hi there,
I am wondering if there is any way to display different named ranges based on a cell value? Typing “= range” displays the range, but is there a way to convert a cell value with a range name so that it displays the whole range? Right now if I type =E3 I am just getting the title of the named range returned instead of the values. Is there some function that will display the values instead of the title?
For a little more context - I have a list of tasks that need to be performed based on the month and week of the month. The input of the month and week return Month1Week1 which lines up with a list of tasks. I want these to be displayed based on the inputs- hoping I can use the named range method but open to other ideas. Filtering will not work for this scenario as some tasks occur all weeks, even weeks, odd weeks, etc.
Thank you in advance for any help!
