Sumproduct function * vlookup

[hugpuf]

Hi!

I have a list of products with their attached retail prices.

PAGE 2 PRICES.PNG

On another sheet, a list of that day's completed production jobs gets populated by code and quantity.

PAGE 1.PNG

I was wondering if there is a code to give a single figure return to calculate the total retail sale price value for that day. I imagine it has something to do with a SUMPRODUCT(VLOOKUP()) type of thing, however I couldnt quite manage the syntax on my own.

Any help would be greatly appreciated!


Hugo

[hugpuf]

I have attached a dummy copy! hope it helps!

It has a macro activated by ctrl+b
but that shouldnt really be relevant

[Phuocam]

Try this in B2:

=SUMIF(PRICES!A:A,A2&"*",PRICES!B:B)