Spreadsheet: 145913d1331813473-lookup-and-match-information-based-on-a-date-match-informationv2
Sheet: Sheet1

Date | Route | Account | Order Location | Order Number |  |  |  | Insert Date | Route | Account | Order Location | Order Number
2012-01-14 00:00:00 | 845 | 868075 | SO17 | 8975 |  |  |  | 2012-01-16 00:00:00 | 797 | 434563 | 1 Fast Bulk   Manual | 604
2012-01-14 00:00:00 | 300 | 223214 | SO17 | 2865 |  |  | Starts at row | 8 | 669 | 868067 | 4 Slow Bulk Manual | 622
2012-01-14 00:00:00 | 296 | 868737 | SO17 | 4977 |  |  | No of rows | 12 | 857 | 860569 | 1 Fast Bulk   Manual | 1930
2012-01-14 00:00:00 | 361 | 285858 | 97 Automat | 8436 |  |  |  |  | 824 | 358267 | 40 Fridge | 6022
2012-01-14 00:00:00 | 818 | 942722 | 40 Fridge | 7609 |  |  |  |  | 668 | 853754 | 1 Fast Bulk   Manual | 586
2012-01-14 00:00:00 | 819 | 359224 | 40 Fridge | 5688 |  |  |  |  | 395 | 233049 | SO2 | 8751
2012-01-16 00:00:00 | 797 | 434563 | 1 Fast Bulk   Manual | 604 |  |  |  |  | 850 | 857342 | 1 Fast Bulk   Manual | 1371
2012-01-16 00:00:00 | 669 | 868067 | 4 Slow Bulk Manual | 622 |  |  |  |  | 798 | 948067 | SO97 | 6683
2012-01-16 00:00:00 | 857 | 860569 | 1 Fast Bulk   Manual | 1930 |  |  |  |  | 669 | 232512 | SO97 | 6667
2012-01-16 00:00:00 | 824 | 358267 | 40 Fridge | 6022 |  |  |  |  | 862 | 800250 | SO97 | 6747
2012-01-16 00:00:00 | 668 | 853754 | 1 Fast Bulk   Manual | 586 |  |  |  |  | 862 | 862797 | SO97 | 6748
2012-01-16 00:00:00 | 395 | 233049 | SO2 | 8751 |  |  |  |  | 387 | 390146 | 1 Fast Bulk   Manual | 5093
2012-01-16 00:00:00 | 850 | 857342 | 1 Fast Bulk   Manual | 1371 |  |  |  |  | - | - | - | -
2012-01-16 00:00:00 | 798 | 948067 | SO97 | 6683 |  |  |  |  | - | - | - | -
2012-01-16 00:00:00 | 669 | 232512 | SO97 | 6667 |  |  |  |  | - | - | - | -
2012-01-16 00:00:00 | 862 | 800250 | SO97 | 6747 |  |  |  |  | - | - | - | -
2012-01-16 00:00:00 | 862 | 862797 | SO97 | 6748 |  |  |  |  | - | - | - | -
2012-01-16 00:00:00 | 387 | 390146 | 1 Fast Bulk   Manual | 5093 |  |  |  |  | - | - | - | -
2012-01-19 00:00:00 | 395 | 294405 | 1 Fast Bulk   Manual | 578 |  |  |  |  | - | - | - | -
2012-01-19 00:00:00 | 990 | 875229 | 4 Slow Bulk Manual | 3818 |  |  |  |  | - | - | - | -
2012-01-19 00:00:00 | 913 | 315234 | SO2 | 3590 |  |  |  |  | - | - | - | -
2012-01-19 00:00:00 | 881 | 837492 | SO17 | 3615 |  |  |  |  | - | - | - | -
2012-01-19 00:00:00 | 890 | 868729 | SO97 | 3456
2012-01-19 00:00:00 | 865 | 945279 | SO17 | 1143
2012-01-19 00:00:00 | 667 | 108779 | 97 Automat | 4160
2012-01-19 00:00:00 | 384 | 393991 | SO17 | 7222
2012-01-20 00:00:00 | 838 | 234971 | 97 Automat | 1250
2012-01-20 00:00:00 | 345 | 341958 | 21 Pams | 6207
2012-01-20 00:00:00 | 345 | 328807 | 21 Pams | 5817
2012-01-20 00:00:00 | 882 | 868927 | 97 Automat | 5099
2012-01-23 00:00:00 | 865 | 946525 | 1 Fast Bulk   Manual | 4657
2012-01-23 00:00:00 | 75 | 132316 | SO17 | 7482
2012-01-23 00:00:00 | 74 | 210930 | SO97 | 9545
2012-01-23 00:00:00 | 76 | 876425 | SO97 | 9552
2012-01-24 00:00:00 | 74 | 227116 | 97 Automat | 9197
2012-01-24 00:00:00 | 840 | 868257 | 4 Slow Bulk Manual | 4117
2012-01-24 00:00:00 | 864 | 852376 | 2 Cath  Manual | 5147
2012-01-24 00:00:00 | 882 | 358564 | SO97 | 7754
2012-01-24 00:00:00 | 76 | 348482 | SO16 | 3019
2012-01-24 00:00:00 | 303 | 324236 | 1 Fast Bulk   Manual | 2624
2012-01-24 00:00:00 | 304 | 325753 | 1 Fast Bulk   Manual | 2630
2012-01-24 00:00:00 | 395 | 430819 | SO2 | 7794
2012-01-24 00:00:00 | 861 | 867655 | 97 Automat | 2114
2012-01-24 00:00:00 | 861 | 867655 | 97 Automat | 2114
2012-01-24 00:00:00 | 386 | 430413 | 1 Fast Bulk   Manual | 3068
2012-01-24 00:00:00 | 361 | 375287 | 1 Fast Bulk   Manual | 8819
2012-01-24 00:00:00 | 394 | 289975 | 1 Fast Bulk   Manual | 3096
2012-01-24 00:00:00 | 394 | 216937 | 1 Fast Bulk   Manual | 3100
2012-01-24 00:00:00 | 848 | 19901 | 97 Automat | 4532
2012-01-24 00:00:00 | 74 | 227116 | 98 Automat | 9197
2012-01-25 00:00:00 | 844 | 437947 | 1 Fast Bulk   Manual | 5509
2012-01-25 00:00:00 | 865 | 948844 | 1 Fast Bulk   Manual | 1986
2012-01-25 00:00:00 | 301 | 324806 | 41 Fridge Secure | 2588
2012-01-25 00:00:00 | 304 | 325753 | 41 Fridge Secure | 2589
2012-01-25 00:00:00 | 897 | 868299 | SO97 | 3930
2012-01-25 00:00:00 | 670 | 226829 | SO97 | 3602
2012-01-25 00:00:00 | 670 | 868026 | SO97 | 3605
2012-01-25 00:00:00 | 895 | 432112 | SO97 | 3913
2012-01-26 00:00:00 | 840 | 868257 | 4 Slow Bulk Manual | 1084
2012-01-26 00:00:00 | 202 | 868869 | SO97 | 3198
2012-01-26 00:00:00 | 202 | 329698 | SO97 | 3199
2012-01-26 00:00:00 | 847 | 883157 | 19 Cd Pams | 978
2012-01-26 00:00:00 | 847 | 883157 | 20 Controlled Drugs | 979
2012-01-26 00:00:00 | 847 | 883157 | 21 Pams | 980
2012-01-26 00:00:00 | 847 | 883157 | 65 Highly Flammable | 982
2012-01-26 00:00:00 | 875 | 850396 | SO97 | 6403
2012-01-27 00:00:00 | 889 | 446450 | 97 Automat | 4355
2012-01-27 00:00:00 | 385 | 230482 | 97 Automat | 2615
2012-01-27 00:00:00 | 385 | 423442 | 97 Automat | 2626
2012-01-27 00:00:00 | 387 | 452060 | 19 Cd Pams | 1346
2012-01-27 00:00:00 | 668 | 357483 | SO12 | 293
2012-01-27 00:00:00 | 840 | 867739 | SO97 | 5034
2012-01-27 00:00:00 | 296 | 92544 | SO97 | 9211
2012-01-27 00:00:00 | 296 | 92544 | SO97 | 9212
2012-01-27 00:00:00 | 296 | 92544 | SO97 | 9213
2012-01-28 00:00:00 | 845 | 868075 | 1 Fast Bulk   Manual | 3128
2012-01-28 00:00:00 | 304 | 168419 | 1 Fast Bulk   Manual | 7864
2012-01-28 00:00:00 | 842 | 860551 | SO16 | 6051
2012-01-28 00:00:00 | 838 | 944827 | 97 Automat | 616
2012-01-30 00:00:00 | 832 | 345587 | SO97 | 2187
2012-01-30 00:00:00 | 303 | 944678 | SO97 | 2019
2012-01-30 00:00:00 | 387 | 390138 | SO97 | 2075
2012-01-30 00:00:00 | 386 | 321935 | 97 Automat | 9986
2012-01-31 00:00:00 | 798 | 948935 | 97 Automat | 8978
2012-01-31 00:00:00 | 799 | 868943 | 97 Automat | 396
2012-01-31 00:00:00 | 874 | 237743 | 1 Fast Bulk   Manual | 2831
2012-01-31 00:00:00 | 876 | 351981 | 97 Automat | 7403
2012-01-31 00:00:00 | 860 | 946525 | 97 Automat | 8321
2012-02-01 00:00:00 | 797 | 394577 | SO17 | 9258
2012-02-01 00:00:00 | 835 | 246710 | SO12 | 4883
2012-02-01 00:00:00 | 387 | 257808 | SO12 | 4882
2012-02-01 00:00:00 | 387 | 257808 | SO97 | 4836
2012-02-01 00:00:00 | 387 | 257808 | SO2 | 4869
2012-02-01 00:00:00 | 384 | 257360 | SO97 | 4830
2012-02-01 00:00:00 | 874 | 347880 | SO97 | 4852
2012-02-01 00:00:00 | 384 | 257360 | SO12 | 4880
2012-02-01 00:00:00 | 384 | 257360 | SO12 | 4868
2012-02-02 00:00:00 | 888 | 110080 | 97 Automat | 7883
2012-02-02 00:00:00 | 386 | 175208 | 97 Automat | 8891
2012-02-02 00:00:00 | 899 | 362426 | 97 Automat | 8386
2012-02-03 00:00:00 | 358 | 324913 | 97 Automat | 8741
2012-02-03 00:00:00 | 845 | 856039 | SO17 | 9883
2012-02-03 00:00:00 | 75 | 868745 | SO97 | 1192
2012-02-03 00:00:00 | 850 | 861304 | SO16 | 5973
2012-02-03 00:00:00 | 860 | 909887 | SO97 | 2111
2012-02-03 00:00:00 | 993 | 864905 | SO12 | 2461
2012-02-03 00:00:00 | 885 | 423054 | 97 Automat | 7139
2012-02-03 00:00:00 | 670 | 172403 | 97 Automat | 7427
2012-02-04 00:00:00 | 667 | 861179 | 97 Automat | 3006
2012-02-04 00:00:00 | 828 | 374447 | SO97 | 874
2012-02-04 00:00:00 | 885 | 432054 | 1 Fast Bulk   Manual | 7127
2012-02-04 00:00:00 | 394 | 229112 | 65 Highly Flammable | 2112
2012-02-04 00:00:00 | 845 | 288944 | 1 Fast Bulk   Manual | 6550