Model Output Summary

[happyhungarian]

Hi, I have a model where the user can select from a drop-down menu a list of options to see various results. The result fields that are populated are exactly the same no matter which option the user selects. I was wondering if it's possible to have a separate sheet that will essentially summarize the outputs of all potential drop-down menu selections onto one sheet (one column for each option and each row having the same output category). In essence it's kind of like a data table but with only one input.

Thanks!

Jesse

Edit: And to add some context, the reason this isn't quite so straight forward is that the results are summaries from time based calculations so it wouldn't be as simple as just replicating the results calculations on a summary sheet. The summary will basically need to calculate the results in the background in the same way a data table does. Hope that makes sense!

 

[coulombevin]

Hi happyhungarian,

In the sheet summay I would do something like that (see formulas):

Classeur1
	A	B	C
1	Drop down list	Result 1	1A
2	optionA	Result 2	2A
summaryPage

Cell Formulas
Range	Formula
C1:C2	C1	=IF($A$2="","",IFERROR(VLOOKUP($B1,tableInfo!$A:$C,MATCH($A$2,tableInfo!$1:$1,0),FALSE),""))

Cells with Data Validation
Cell	Allow	Criteria
A2	List	optionA;optionB

The sheet tableInfo refer as a table looking like this.

Classeur1
	A	B	C
1	Datas	optionA	optionB
2	Result 1	1A	1B
3	Result 2	2A	2B
tableInfo

Hope it help. If not, please provide more information and example with table if possible.

Bests regards,

Vincent