Multiply using various criteria

[KeithStew]

Good day Excel Guru's

I have been trying to achieve the following with no success, I have tried using SUMIF with SUMPRODUCT but I have not been successful. I would greatly appreciate any guidance on the problem I am trying to solve.

In Summary I am trying to workout number of boxes per pallet, the challenge that I have is that there are four different box sizes supplied. I have categorised them and now I would like to multiply the 3 month stock holding by the number of boxes per pallet so I have a palletised figure to work with. If the box size is large then it needs to use the large number and that would apply for medium, small etc.

3 Months	QTY Per Box	Box QTY	Palletised	BOX Size
39	6	7		LARGE			Pallet 110 x 110 x 120
19	50	1		SMALL		Small	549
23	30	1		SMALL		Medium	261
18	30	1		SMALL		Large	144
6	40	1		SMALL		L	32

<tbody>
</tbody>

Thank you in advance.

 

[Kamolga]

I would simply use vlookup

[/URL][/IMG]

 

[KeithStew]

Thank you I will try that, sometimes one tries to overcomplicate these things