Equivalent of a multiple VLookup?

[WasWodge]

Don't know if this is possible but here goes.The scenario is I have various products that are the same product but have different product codes (Due to free codes, special pricing for different customers etc).
They all sit in the same location in the warehouse and I need a total for each product on order for each group of product codes. This total needs to appear on each row of the code so that we can perform a VLOOKUP on any of the codes and get the total sales per product to appear.
To clarify I have attached a workbook with a very simplified start and result sheet.

Thanks in advance for any suggestions or even the phrase "not possible" if that is the case