Multilpy Formula based on Scenario

[boo203]

Hi and good day!

I need help with finding the write formula for multiplying the volume (row 9), based on the scenario (row 8)

for example, if Scenario 1 is chosen (B8) then the results would like below:

B10 = 100*25%
B11 = 100*25%
B12 = 100*50%

and so on for the rest, might add 2-3 more scenarios later on.

don't necessarily need to match A-C in both tables if it will make it less complicated, I'll ensure that the order remains the same.

Thank you.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E
1		1	2
2	A	25%	50%
3	B	25%	50%
4	C	50%	0%
5
6
7
8		1	2	2	1
9		100	200	300	300
10	A	25	100	150	75
11	B	25	100	150	75
12	C	50	0	0	150
Sheet6

Cell Formulas
Range	Formula
B10:E12	B10	=SUMPRODUCT(($A$2:$A$4=$A10)*($B$1:$C$1=B$8)*($B$2:$C$4))*B$9

 

[boo203]

How about

Fluff.xlsm
	A	B	C	D	E
1		1	2
2	A	25%	50%
3	B	25%	50%
4	C	50%	0%
5
6
7
8		1	2	2	1
9		100	200	300	300
10	A	25	100	150	75
11	B	25	100	150	75
12	C	50	0	0	150
Sheet6

Cell Formulas
Range	Formula
B10:E12	B10	=SUMPRODUCT(($A$2:$A$4=$A10)*($B$1:$C$1=B$8)*($B$2:$C$4))*B$9

This is perfect! Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.