Muliply values with vlookup?

[Pojzon]

Help table	Amount		Result table	1	2	3	4	5	6	7	8
Name1	5		Name1	1		3	4	5		3
Name2	10		Name2		2		3		4		2
Name3	15		Name3	3		3				3
Name4	20		Name4		4			5	1		1
			Multiplied sum	50	100	60	50	125	60	60	40

<tbody>
</tbody>

Hello,
I need to multiply values from help table with result table. In final file there would be around 50 names. I tried using vlookup, but with no luck. Is there any simple way that I could automate this? Thank you for any help.

 

[DRSteele]

Welcome to the forum.

Summing arrays multiplied together is an easier way to extract the conditional values.

Copy E6 across.

	A	B	C	D	E	F	G	H	I	J	K	L
1	Help table	Amount		Result table	1	2	3	4	5	6	7	8
2	Name1	5		Name1	1		3	4	5		3
3	Name2	10		Name2		2		3		4		2
4	Name3	15		Name3	3		3				3
5	Name4	20		Name4		4			5	1		1
6				Multiplied sum	50	100	60	50	125	60	60	40

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula E6 =SUMPRODUCT($B$2:$B$5*E2:E5) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

<strike></strike>

 

[Pojzon]

Thank you very much for answer, but I've got another question. I believe this method will only work as long as order of names in help table is always the same as order in result table. Is there anyway to make it work with different order?

 

[DRSteele]

Yes, there is. Simply include another array.

This goes in E6.

=SUMPRODUCT(($D$2:$D$5=$A$2:$A$5)*$B$2:$B$5*E2:E5)