Referencing the text within a cell as the name of an array

[pct5003]

Hello All,

I am using Excel 2010. I named a data set System and on another spread sheet I have a column for the name of the data sets. I want to write a vlookup and use the column with the names of the data set, lets use B2, as the array. For example:

=vlookup($A2,B2,18,false)

I also tried:

=vlookup($A2,"{"&B2&"}",18,false)


B2 is the data set name, in this example System

I want the array to be dynamic so that I do not have to change it for every single data source I have. Any help would be greatly appreciated.

 

[BrianMH]

I'm not sure exactly what you are trying to achieve.

Are you trying to refer to a named range and the named range is in B2?

If so try this

=vlookup($A2,indirect(b2),18,false)

 

[pct5003]

Yes that is it. Thank you sir.