Spreadsheet: 740670d1626446255-xlookup-lookup-value-may-contain-text-that-is-not-included-in-lookup-array-and-vice-versa-my-problem
Sheet: Summary

Pick up# |  |  | Pick up Lease | Pick lease | Dest | Dest Name | Material | Material Name | [NAME] | H2S | RR | Dispatch #
986610 |  |  | M600456 | WILCKEN 16-23 4-2-23-14-1H | [NAME] | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986610
986114 |  |  | M600367 | LAMB UT 1-16 4-1-10-3-7H | [NAME] | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986114
986119 |  |  | [NAME] | LAMB UT 1-16 4-1-9-4-1H | [NAME] | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986119
980162 |  |  | [NAME] | FEDERAL 8-2D-64 | RP3012 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 980162
985428 |  |  | [NAME] | BBC 4-20C5 | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 985428
985928 |  |  | M594609 | RETZKE 3-25C4 | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 985928
983466 |  |  | M592150 | DW LANDFILL 4-32B4 | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 983466
985429 |  |  | M594434 | UTE TRIBAL 3-25A3 | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 985429
986598 |  |  | M594616 | PEKEV UT 2-29 3-1-29-32-1 | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986598
981793 |  |  | M595255 | 03-16-21-3-1E-H1 HICKEN TRIBAL | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 981793
980739 |  |  | M593141 | UTE TRIBAL 2-26-54 | RP3012 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 980739
986607 |  |  | M595921 | Nooh Tuh Vweep 16-9 3-2-16-21-11H | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986607
986606 |  |  | M595920 | Nooh Tuh Vweep 16-9 3-2-16-21-2H | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986606
986612 |  |  | M600456 | WILCKEN 16-23 4-2-23-14-1H | [NAME] | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986612
986604 |  |  | M595919 | Nooh Tuh Vweep 16-9 3-2-16-21-42H | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986604
986473 |  |  | M600509 | REMUND 26-25-C4 BATTERY | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986473
985936 |  |  | M600041 | EP ENERGY 25-26-C5 BATTERY | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 985936
986476 |  |  | M600509 | REMUND 26-25-C4 BATTERY | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986476
986478 |  |  | M600509 | REMUND 26-25-C4 BATTERY | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986478
986493 |  |  | M595480 | GOERGEN 9-13-14-C5 | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986493
986483 |  |  | M600509 | REMUND 26-25-C4 BATTERY | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986483
986484 |  |  | M600509 | REMUND 26-25-C4 BATTERY | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986484
986485 |  |  | M600509 | REMUND 26-25-C4 BATTERY | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986485
986495 |  |  | M600041 | EP ENERGY 25-26-C5 BATTERY | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986495
986486 |  |  | M600509 | REMUND 26-25-C4 BATTERY | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 986486
987021 |  |  | M10661 | ODEKIRK 4-36-8-17 | RP3012 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 987021
987012 |  |  | [NAME] | Nooh Tuh Vweep 4-16 3-2-16-21-4H | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 987012
983864 |  |  | [NAME] | 03.5-34-3-1E-H1 Szyndrowski | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 983864
987010 |  |  | M594801 | Beal UT 13-34 4-3-4-9-1H | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 987010
984707 |  |  | M593791 | SHIELDS 3-3-13-24-3H | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 984707
984795 |  |  | M592979 | State [NAME] | RP3012 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 984795
987019 |  |  | M595920 | Nooh Tuh Vweep 16-9 3-2-16-21-2H | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 987019
987018 |  |  | M595902 | Nooh Tuh Vweep 16-9 3-2-16-21-3H | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 987018
987016 |  |  | M595919 | Nooh Tuh Vweep 16-9 3-2-16-21-42H | RP7088 | Salt Lake City Trucking | 14 | Petroleum Crude Oil |  |  |  | 987016