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.

Table1	Volumes per year
	Year 1	Year 2	Year 3	Year 4	Year 5
Volume Scenario 1	1	1	1	1	1
Volume Scenario 2	2	2	2	2	2
Volume Scenario 3	3	3	3	3	3
Volume Scenario 4	4	4	4	4	4

<tbody>
</tbody>

Table 2		Costs / per unit
Cost Description	Vol Scenario	Year 1	Year 2	Year 3	Year 4	Year5
Cost Position 1	Volume Scenario 3	10	10	10	10	10
Cost Position 2	Volume Scenario 1	20	20	20	20	20

<tbody>
</tbody>

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

Is this possible?

Thank You!!