Index - Lookup - Multiple Results - one cell / no VBA - 2 Dimensional table

[belle888]

Hello and Happy New Year!!

The target is: I like to have an array with the total costs per year (cost per unit (see table 2) * corresponding volume (see table 1)) for the entered cost positions.
Following constraints are given: I like to have the array with the total costs for each year in one cell (e.g. with array formula, index, sumifs, or whatever it takes). VBA is not possible.

My problem is that I cant "allocate" the volumes to the costs correspondingly.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Table1[/TD]
[TD]Volumes per year[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Year 1
[/TD]
[TD]Year 2
[/TD]
[TD]Year 3
[/TD]
[TD]Year 4
[/TD]
[TD]Year 5
[/TD]
[/TR]
[TR]
[TD]Volume Scenario 1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Volume Scenario 2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Volume Scenario 3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Volume Scenario 4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Table 2[/TD]
[TD][/TD]
[TD]Costs / per unit[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost Description
[/TD]
[TD]Vol Scenario
[/TD]
[TD]Year 1
[/TD]
[TD]Year 2
[/TD]
[TD]Year 3
[/TD]
[TD]Year 4
[/TD]
[TD]Year5
[/TD]
[/TR]
[TR]
[TD]Cost Position 1[/TD]
[TD]Volume Scenario 3[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Cost Position 2[/TD]
[TD]Volume Scenario 1[/TD]
[TD]20[/TD]
[TD]20[/TD]
[TD]20[/TD]
[TD]20[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]


Expected array within one cell
{30,30,30,30,30
20,20,20,20,20}

Is this possible?

Thank You!!