Using a Cell Reference rather than a Named Range in a VLOOKUP

[Madraykin]

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

 

[Eric W]

Try:

=vlookup(A1,INDIRECT(T1),2,FALSE)

 

[Madraykin]

Ooooh thanks Eric (sorry for late reply I was away this weekend) - will try that out. Have never had cause to use INDIRECT before so looking forward to it!