Dynamic Vlookup Ranges?

[shellp]

Hello

I have a list of 17 metrics and I have the definitions, calculation descriptions etc. set up in a table so that when the user selects the metric from the drop down list, the specifics per metric show up. Now I would also like to show the data per the specific metric but each metric has it's own worksheet and the values could be in a different column than another. What I'd like to do is use set up another vlookup so that the range and column for the can be extracted and then used to get the data from the specific worksheet.

Is this possible? Thanks.

 

[Eric W]

It should be possible. Depends on how your data is set up, could you show your dashboard sheet, as well as a couple of the metric sheets, and the data you want to show? The key to making this work is probably the INDIRECT function.