Hi Lovely People!
I'm sure I have got this to work before but for the life of me I can't do it now!
So I have about 8 different named ranges, identical tables but with different data in them representing different scenarios. I use a dropdown selection box to automatically update visualisations based on which scenario I'm viewing.
The main graph is based on a table amalgamating lots of data together and I now need to move data from one of the named ranges into the graph data table, but it needs to be the named range that matches a value in cell T1, which updates automatically when you select from the dropdown (are you still with me??? )
In short, instead of a vlookup that points directly at a named range (ie =vlookup(A1,NamedRange,2,FALSE), is it possible for me to say =vlookup(A1,T1,2,FALSE) where T1 holds the name of the required range???
Thanks so much in advance!!!
Mads
I'm sure I have got this to work before but for the life of me I can't do it now!
So I have about 8 different named ranges, identical tables but with different data in them representing different scenarios. I use a dropdown selection box to automatically update visualisations based on which scenario I'm viewing.
The main graph is based on a table amalgamating lots of data together and I now need to move data from one of the named ranges into the graph data table, but it needs to be the named range that matches a value in cell T1, which updates automatically when you select from the dropdown (are you still with me??? )
In short, instead of a vlookup that points directly at a named range (ie =vlookup(A1,NamedRange,2,FALSE), is it possible for me to say =vlookup(A1,T1,2,FALSE) where T1 holds the name of the required range???
Thanks so much in advance!!!
Mads