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.
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.