Multiply & sum of numbers and the equivalents of datas (Array sum in array)

[McExcel]

Hi everyone! First post ! Sorry for the title :D My English is not excellent so I show my problem on an example:

A	3,13		equivalents
C	2,62		A	1
C	4,12		B	2
F	10,13		C	3
D	83,2		D	4
			E	5
			F	6
	Question: How can multiply Equivalents of A,B,C... in one step?
	A*3,13 + C*2,62 + C*4,12 + F*10,13 + D*83,2

<tbody>
</tbody>

The answer should be:120,2 sorry 416,93


I've tried vlookup and with array formulas using (control+shift+enter). But I couldn't solve.

For example:

={SUM(VLOOKUP(A1:A5,equivalents,2,false),B1:B5)} .... not working

 

[billszysz]

This one is better than previous....but still exotic

=SUM(IF($C$1:$C$5="available",INDEX($E$2:$E$7,N(CHOOSE(1,MATCH($A$1:$A$5,$D$2:$D$7,0)))),0)*$B$1:$B$5)

 

[Qing Liu]

My approach:

=SUM((A1:B5=TRANSPOSE(D2:D7)) * TRANSPOSE(E2:E7) * B1:B5)

(Array-enter the above formula)