SUMPRODUCT with more than one condition

[nolodani]

Hello all,

This is my first time posting in the forum (or any forum, for that matter), so please bear with me. I've been poking around for a while but still haven't been able to find a solution.

In one worksheet I have a list of times, each with a price, and a date for each list as a header. In another worksheet, I have the same list, with the quantity of each item, and again the date as a header. With simplified figures, it would look something like this:

Sheet1
A B
21-02-2015
1 PERSIL $ 3,0
2 GARLIC $ 3,0
3 RUCULA $ 2,0
4 CUCUMBER $ 2,0
5 CHERRY TOMATOES $ 0,5
6 TOMATOES $ 0,5
7 CARROTTS $ 1,0
8 ZUCCHINI $ 2,0
9 RED PEPPER $ 1,0
10 GREEN PEPPER $ 1,0
11 POTATOES $ 1,0
12 PEACHES $ 1,0
13 ORANGES $ 1,0

Sheet2
A B
24-02-2015
1 PERSIL 2
2 GARLIC 2
3 RUCULA 2
4 CUCUMBER 2
5 CHERRY TOMATOES 2
6 TOMATOES 2
7 CARROTTS 2
8 ZUCCHINI 2
9 RED PEPPER 2
10 GREEN PEPPER 2
11 POTATOES 2
12 PEACHES 2
13 ORANGES 2

I basically want a formula to get the value of the whole list. If they were contiguous it would be a simple SUMPRODUCT. However, not only are they in separate worksheets, but on top of it while the quantities of each item are bound to change each week, the price probably won't. So I want the formula to lookup the most recent price list, in relation to the product list.

I've seen many examples for SUMPRODUCT to add only some of the items, but not for the whole list, with the condition at the header. I've been poking around with combining it with INDEX;MATCH, to no avail.

There is a work book attached in case it helps.

Thanks a lot beforehand!