Spreadsheet: 145907d1331810433-lookup-and-match-information-based-on-a-date-match-information
Sheet: Sheet1

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