Dynamic Vlookup Ranges?

shellp

Board Regular
Joined
Jul 7, 2010
Messages
173
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,625
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,814
Messages
5,598,249
Members
414,219
Latest member
ruchperformive

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top