Rate Card - Horizontal items - 2 rate card costs

[sward1001]

	A	B	C	D	E
1	PRODUCT	Q1	Q2	Q3	TOTAL
2	VOLUMES - SUPPLIER 1	1	2		60
3	VOLUMES - SUPPLIER 2			1	25
4
5
	(On separate worksheet)	SUPPLIER 1	SUPPLIER 2
	Q1	50	45
	Q2	5	8
	Q3	15	25

<tbody>
</tbody>

Hi - can anyone assist, what formula would give me the totals by referencing the product costs from 2 suppliers to get a total ? eg E2 = 1*50 + 2*5

I have done something similar years ago but cant remember - was it an array function?

Many Thanks in advance.

 

[sward1001]

To add to this the worksheet contains 50 + products and rates..

thanks

 

[sward1001]

anyone?