Spreadsheet: 673077d1587147954-index-match-help-data-sample-for-index-match
Sheet: Sheet1

Example ANSWER REQUIRED |  |  |  |  |  |  |  |  |  |  |  | MY Formula NOT Working
 | 2020-04-13 00:00:00 | 2020-04-20 00:00:00 | 2020-04-27 00:00:00 |  |  |  |  |  |  |  |  |  | 2020-04-13 00:00:00 | 2020-04-20 00:00:00 | 2020-04-27 00:00:00
Part 5 | 6 | 10 | 9 |  | The values in the answer I require are from each |  |  |  |  |  |  | Part 5
Part 11 | 20 | 18 | 0 |  | column titled "Build" in my data set for each date week |  |  |  |  |  |  | Part 11
Part E | 10 | 15 | 25 |  | I want to do this via INDEX MATCH incase data shifts around |  |  |  |  |  |  | Part E
 |  |  | OUTPUT |  |  |  |  |  |  |  | OUTPUT |  |  |  |  | OUTPUT
 |  | WEEK NUMBER | 16 |  |  |  |  |  |  |  | 17 |  |  |  |  | 18
 | 2020 |  | 2020-04-13 00:00:00 |  |  |  |  |  |  |  | 2020-04-20 00:00:00 |  |  |  |  | 2020-04-27 00:00:00
 |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  | 4 |  |  |  |  | 4
Item | Description | MOH | Opening Stock | Shipped this week | Orders | Orders Covered | MOH Covered | Packed WTD | Build | [NAME] | Opening Stock | Orders | Orders Covered | MOH Covered | Build | Opening Stock | Orders | Orders Covered | MOH Covered | Build
 | Product 1 | 116 | 1388 |  |  |  |  |  | 165 |  |  |  |  |  | 82 |  |  |  |  | 366
Part 1 | Product 1 | 3 | 2 | 0 | 0 | OK | NO | 0 |  | 0 | 2 | 2 | OK | NO | 5 | 5 | 0 | OK | OK
Part 2 | Product 1 | 0 | 0 | 0 | 0 | OK | OK | 0 |  | 0 | 0 | 0 | OK | OK |  | 0 | 11 | SHORT | NO | 100
Part 3 | Product 1 | 6 | 23 | 0 | 0 | OK | OK | 0 |  | 0 | 23 | 0 | OK | OK |  | 23 | 0 | OK | OK
Part 4 | Product 1 | 30 | 548 | 45 | 0 | OK | OK | 5 | 5 | 0 | 508 | 60 | OK | OK |  | 448 | 0 | OK | OK | 142
Part 5 | Product 1 | 10 | 477 | 30 | 0 | OK | OK | 6 | 6 | 0 | 453 | 81 | OK | OK | 10 | 382 | 34 | OK | OK | 9
Part 6 | Product 1 | 15 | 129 | 17 | 0 | OK | OK | 38 | 38 | 0 | 150 | 40 | OK | OK | 47 | 157 | 14 | OK | OK | 40
Part 7 | Product 1 | 0 | 0 | 0 | 0 | OK | OK | 0 |  | 0 | 0 | 0 | OK | OK |  | 0 | 0 | OK | OK | 5
Part 8 | Product 1 | 0 | 0 | 0 | 0 | OK | OK | 0 |  | 0 | 0 | 0 | OK | OK |  | 0 | 0 | OK | OK | 20
Part 9 | Product 1 | 0 | 0 | 0 | 0 | OK | OK | 1 | 25 | -24 | 25 | 25 | OK | OK |  | 0 | 0 | OK | OK | 35
Part 10 | Product 1 | 0 | 0 | 0 | 0 | OK | OK | 0 |  | 0 | 0 | 0 | OK | OK |  | 0 | 0 | OK | OK | 15
Part 11 | Product 1 | 30 | 119 | 0 | 0 | OK | OK | 20 | 20 | 0 | 139 | 10 | OK | OK | 18 | 147 | 0 | OK | OK
Part 12 | Product 1 | 2 | 2 | 0 | 0 | OK | OK | 0 |  | 0 | 2 | 0 | OK | OK |  | 2 | 0 | OK | OK
Part 13 | Product 1 | 20 | 55 | 8 | 0 | OK | OK | 59 | 59 | 0 | 106 | 11 | OK | OK | 2 | 97 | 3 | OK | OK
Part 14 | Product 1 | 0 | 3 | 0 | 0 | OK | OK | 0 |  | 0 | 3 | 0 | OK | OK |  | 3 | 0 | OK | OK
Part 15 | Product 1 | 0 | 20 | 0 | 0 | OK | OK | 12 | 12 | 0 | 32 | 0 | OK | OK |  | 32 | 0 | OK | OK
Part 16 | Product 1 | 0 | 10 | 0 | 0 | OK | OK | 0 |  | 0 | 10 | 0 | OK | OK |  | 10 | 0 | OK | OK
 | Product 2 | 0 | 459 |  |  |  |  |  | 14 |  |  |  |  |  | 541 |  |  |  |  | 25
Part A | Product 2 | 0 | 206 | 0 | 0 | OK | NO | 4 | 4 | 0 | 210 | 140 | OK | NO | 454 | 524 | 254 | OK | OK
Part B | Product 2 | 0 | 10 | 10 | 0 | OK | OK | 0 |  | 0 | 0 | 0 | OK | NO |  | 0 | 0 | OK | NO
Part C | Product 2 | 0 | 72 | 0 | 0 | OK | OK | 0 |  | 0 | 72 | 76 | SHORT | NO |  | -4 | 0 | SHORT | NO
Part D | Product 2 | 0 | 35 | 0 | 0 | OK | OK | 1 |  | 1 | 35 | 10 | OK | OK |  | 25 | 0 | OK | OK
Part E | Product 2 | 0 | 50 | 0 | 0 | OK | OK | 10 | 10 | 0 | 60 | 50 | OK | NO | 15 | 25 | 0 | OK | NO | 25