Spreadsheet: 758857d1639129177-index-formula-assistance-to-pull-data-from-multiple-sheets-using-a-single-criterion-invoicing_test_data
Sheet: OctP

Oct_Purchases
DATE | SUPPLIER NAME | INVOICES | ALLOCATED AREA | INVOICE NUMBER | OUR ORDER REF | COST1 | COST2 | COST3 | TOTAL | VAT | PURCHASES | MOTOR EXP | SUNDRIES | TELE | RENT/RATES | RFG CONT | TRANS | SUB / INS | STAY | PROF | SKIP HIRE | PLANT
2021-07-01 00:00:00 | AMAZON |  | BIRMINGHAM | 5755 | AA7464 | 0 | 200 | 18287 | 200 | 33.33 |  |  | 166.67
2021-07-01 00:00:00 | EBAY |  | LONDON | 103606 | LON3637 | 0 | 342 | 18288 | 342 | 57 | 285
2021-07-26 00:00:00 | AMAZON |  | LONDON | 17738 | LON27373 | 0 | 96 | 18289 | 96 | 16 | 80
2021-07-09 00:00:00 | EE |  | LONDON | 17666 | LON3546 | 0 | 2779.2 | 18290 | 2779.2 | 463.2 | 2316
2021-07-16 00:00:00 | AMAZON |  | KENT | 17711 | KEN756 | 0 | 194.4 | 18291 | 194.4 | 32.4 | 162
2021-07-22 00:00:00 | AMAZON |  | LECIESTER | 17729 | LEC9812 | 0 | 2685.7 | 18292 | 2685.7 | 447.62 | 2238.08
2021-07-23 00:00:00 | AMAZON |  | BIRMINGHAM | 17737 | BIRM9373 | 0 | 1643.64 | 18293 | 1643.64 | 273.94 | 1369.7
2021-07-16 00:00:00 | EBAY |  | NEWCASTLE | 17710 | NEW844 | 0 | 2198.52 | 18294 | 2198.52 | 366.42 | 1832.1
2021-07-13 00:00:00 | EBAY |  | LIVERPOOL | 17689 | LIV2727 | 0 | 808.2 | 18295 | 808.2 | 134.7 | 673.5
2021-07-31 00:00:00 | SMYTHS |  | BIRMINGHAM | 21073br_1 | BIRM11818 | 0 | 147.66 | 18296 | 147.66 | 24.61 |  |  | 123.05
2021-06-24 00:00:00 | GREGGS |  | KENT | V01886716603 | [NAME] | 0 | 356.04 | 18297 | 356.04 | 59.34 |  |  |  | 296.7
2021-07-24 00:00:00 | GREGGS |  | [NAME] | V01896455201 | [NAME] | 0 | 337.57 | 18298 | 337.57 | 56.26 |  |  |  | 281.31
2021-07-30 00:00:00 | BONUS PRINT |  | [NAME] | E18594 | SOM1283 | 0 | 166.98 | 18299 | 166.98 | 0 | 166.98
2021-07-02 00:00:00 | [NAME] |  | NORFOLK | 3021008625 | [NAME] | 0 | 1144.3 | 18300 | 1144.3 | 190.72 | 953.58
2021-07-21 00:00:00 | [NAME] |  | NORFOLK | 3021009517 | NOR32727 | 0 | 3556.34 | 18301 | 3556.34 | 592.72 | 2963.62
2021-07-06 00:00:00 | EBAY |  | NORWICH | 113-[PHONE] | NOR2721 | 0 | 12.53 | 18302 | 12.53 |  | 2.09 |  | 10.44
2021-07-26 00:00:00 | EBAY |  | BIRMINGHAM | 28279 | BIRM1427 | 0 | 384 | 18303 | 384 | 64 | 320
2021-07-20 00:00:00 | AMAZON |  | BIRMINGHAM | 6003123 | BIRMING3737 | 0 | 111.84 | 18304 | 111.84 | 18.64 | 93.2
2021-07-12 00:00:00 | MATALAN |  | SOLIHULL | 6000001 | SOL92828 | 0 | 1822.97 | 18305 | 1822.97 | 303.83 | 1519.14
2021-07-06 00:00:00 | PRIMARK |  | SOLIHULL | 5997613 | SOL123 | 0 | 3704.1 | 18306 | 3704.1 | 617.35 | 3086.75
2021-07-08 00:00:00 | SELFRIDGES |  | WOLVERHAMPTON | 5998906 | WOL785 | 0 | 3454.81 | 18307 | 3454.81 | 575.8 | 2879.01
2021-07-19 00:00:00 | FOOTLOCKER |  | PLYMOUTH | 6002555 | WOL4738 | 0 | 2331.79 | 18308 | 2331.79 | 388.63 | 1943.16
" | [NAME] |  | PLYMOUTH | 6002554 | [NAME] | 0 | 2307.95 | 18309 | 2307.95 | 384.66 | 1923.29
2021-07-22 00:00:00 | JUST EAT |  | BIRMINGHAM | 6004248 | PLY28282 | 0 | 23.84 | 18310 | 23.84 | 3.97 | 19.87
2021-07-15 00:00:00 | JUST EAT |  | KENT | 6001580 | KEN1717 | 0 | 2213.42 | 18311 | 2213.42 | 368.9 | 1844.52
" | EBAY |  | NORFOLK | 6001581 | NORFOLK | 0 | 1450.99 | 18312 | 1450.99 | 241.83 | 1209.16
" | BIG MANS FOOD |  | BIRMINGHAM | 6001582 | BIRM27272 | 0 | 4106.95 | 18313 | 4106.95 | 684.49 | 3422.46
" | EE |  | LONDON | 6001562 | LOND | 0 | 1021.31 | 18314 | 1021.31 | 170.22 | 851.09