Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Sales | ||||||||
2 | Sales No | Product | Purchase Date | Sale Date | Sales Value | Purchase Value | Margin | ||
3 | 1 | Baked Beans | 15/08/2006 | 16/08/2006 | 0 | ||||
4 | 2 | Baked Beans | 15/08/2006 | 03/09/2006 | 0 | ||||
5 | 3 | Salt Beef | 02/09/2006 | 15/09/2006 | 0 | ||||
6 | |||||||||
7 | |||||||||
8 | Purchase Values | ||||||||
9 | Product | Date from | Date to | Value | |||||
10 | Baked Beans | 01/08/2006 | 31/08/2006 | 10 | |||||
11 | Macaroni | 01/07/2006 | 31/07/2006 | 2 | |||||
12 | Salt Beef | 38,961 | 30/09/2006 | 11 | |||||
13 | |||||||||
14 | |||||||||
15 | Sales Values | ||||||||
16 | Product | Date from | Date to | Value | |||||
17 | Baked Beans | 01/08/2006 | 31/08/2006 | 12 | |||||
18 | Baked Beans | 01/09/2006 | 30/09/2006 | 17 | |||||
19 | Salt Beef | 01/09/2006 | 30/09/2006 | 22 | |||||
Sheet1 |
Umm, 3rd time lucky?
I have 2 sets of data from which I am trying to match information into a 3rd range (as demonstartated above). I'm familair with index/match as well a vlookup. My problem this time is that there are date ranges involved. Not too sure where to start.
Also, not too sure if this is releavnt place to post but, would this be easier done in Access?