Spreadsheet: 725660d1616781401-pulling-certain-criteria-from-a-string-of-text-and-match-to-a-pallet-number-packaging-invoice-copy
Sheet: Shipper Details 

Part | Description | Quantity | Pallet | Shipping Label | Master [NAME] | Internal Label
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90650 | 92458 | 40887
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90651 | 92458 | 40888 |  |  |  |  |  |  |  |  |  | L | W | H |  |  |  |  | Pallet Number | Number of Boxes | Layers | Caps OR Grips OR Stars
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90652 | 92458 | 40889 |  |  |  |  |  |  |  |  |  | 120 | 80 | 300 |  |  |  |  | 1
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90653 | 92458 | 86070 |  |  |  |  |  |  |  |  |  | 120 | 80 | 360 |  |  | COV |  | 2
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90654 | 92458 | 40880 |  |  |  |  |  |  |  |  |  | 120 | 80 | 450 |  |  | RHL |  | 3
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90655 | 92458 | 86057 |  |  |  |  |  |  |  |  |  | 120 | 80 | 520 |  |  | LHL |  | 4
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90656 | 92458 | 40891 |  |  |  |  |  |  |  |  |  | 120 | 80 | 540 |  |  | N/L |  | 5
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90657 | 92458 | 86071 |  |  |  |  |  |  |  |  |  | 120 | 80 | 600 |  |  | A205 |  | 6
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90658 | 92458 | 86072 |  |  |  |  |  |  |  |  |  | 120 | 80 | 660 |  |  |  |  | 7 |  |  | A205
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90659 | 92458 | 40890 |  |  |  |  |  |  |  |  |  | 120 | 80 | 720 |  |  |  |  | 8
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90660 | 92458 | 91830 |  |  |  |  |  |  |  |  |  | 120 | 80 | 780 |  |  |  |  | 9
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90661 | 92458 | 91831 |  |  |  |  |  |  |  |  |  | 120 | 80 | 840 |  |  |  |  | 10
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90662 | 92458 | 86066 |  |  |  |  |  |  |  |  |  | 120 | 80 | 900 |  |  |  |  | 11
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90663 | 92458 | 86058 |  |  |  |  |  |  |  |  |  | 120 | 80 | 990 |  |  |  |  | 12
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90664 | 92458 | 86059 |  |  |  |  |  |  |  |  |  | 120 | 80 | 400 |  |  |  |  | 13
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90665 | 92458 | 86060 |  |  |  |  |  |  |  |  |  | 120 | 80 | 540 |  |  |  |  | 14
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90666 | 92458 | 40882 |  |  |  |  |  |  |  |  |  | 120 | 80 | 700 |  |  |  |  | 15
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90667 | 92458 | 86061 |  |  |  |  |  |  |  |  |  | 120 | 80 | 850 |  |  |  |  | 16
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90668 | 92458 | 86067 |  |  |  |  |  |  |  |  |  | 120 | 80 | 980 |  |  |  |  | 17
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90669 | 92458 | 86068 |  |  |  |  |  |  |  |  |  | 120 | 80 | 1150 |  |  |  |  | 18
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90670 | 92458 | 40892 |  |  |  |  |  |  |  |  |  | - | - | Total |  |  |  |  | 19
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90671 | 92458 | 40881 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90672 | 92458 | 86063 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
14469301 | 405 COV NARVIK BLACK | 20 | 1 | 90673 | 92458 | 86065 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
Total for Pallet |  | 24 | Linked: 0 | Unlinked: 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
14469301 | 405 COV NARVIK BLACK | 20 | 2 | 90674 | 92477 | 40878 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
14469301 | 405 COV NARVIK BLACK | 20 | 2 | 90675 | 92477 | 40871 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
14469301 | 405 COV NARVIK BLACK | 20 | 2 | 90676 | 92477 | 40872 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
14469301 | 405 COV NARVIK BLACK | 20 | 2 | 90677 | 92477 | 40876 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
14469301 | 405 COV NARVIK BLACK | 20 | 2 | 90678 | 92477 | 40877 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
14469301 | 405 COV NARVIK BLACK | 20 | 2 | 90679 | 92477 | 86055 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
14469301 | 405 COV NARVIK BLACK | 20 | 2 | 90680 | 92477 | 86056 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
14469301 | 405 COV NARVIK BLACK | 20 | 2 | 90681 | 92477 | 40879 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
14469301 | 405 COV NARVIK BLACK | 20 | 2 | 90682 | 92477 | 40886 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
14538401 | 405 COV BRIGHT CHROME | 20 | 2 | 90683 | 92477 | 85963 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
14538401 | 405 COV BRIGHT CHROME | 20 | 2 | 90684 | 92477 | 85964 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
14538401 | 405 COV BRIGHT CHROME | 20 | 2 | 90685 | 92477 | 85965 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
14538401 | 405 COV BRIGHT CHROME | 20 | 2 | 90686 | 92477 | 85966 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
14818301 | 405 COV BRIGHT ATLAS | 20 | 2 | 90687 | 92477 | 86036 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
14818301 | 405 COV BRIGHT ATLAS | 20 | 2 | 90688 | 92477 | 86037 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
14818301 | 405 COV BRIGHT ATLAS | 20 | 2 | 90689 | 92477 | 86038 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
14818301 | 405 COV BRIGHT ATLAS | 20 | 2 | 90690 | 92477 | 86039 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
14818301 | 405 COV BRIGHT ATLAS | 20 | 2 | 90691 | 92477 | 86040 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
14818301 | 405 COV BRIGHT ATLAS | 20 | 2 | 90692 | 92477 | 86035 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
EMPTY |  | 0 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43
Total for Pallet |  | 20 | Linked: 0 | Unlinked: 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90694 | 92147 | 85993 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90695 | 92147 | 85994 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90696 | 92147 | 85995
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90697 | 92147 | 85990
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90698 | 92147 | 85988
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90699 | 92147 | 85996
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90700 | 92147 | 86043
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90701 | 92147 | 86044
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90702 | 92147 | 86045
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90703 | 92147 | 85989
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90704 | 92147 | 86041
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90705 | 92147 | 86042
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90706 | 92147 | 86007
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90707 | 92147 | 86008
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90708 | 92147 | 86004
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90709 | 92147 | 86003
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90710 | 92147 | 85997
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90711 | 92147 | 85998
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90712 | 92147 | 86006
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90713 | 92147 | 86005
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90714 | 92147 | 86000
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90715 | 92147 | 86002
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90716 | 92147 | 85999
14818301 | 405 COV BRIGHT ATLAS | 20 | 3 | 90717 | 92147 | 86001
Total for Pallet |  | 24 | Linked: 0 | Unlinked: 0
13015101 | 405 LHL NARVIK BLACK | 40 | 4 | 90718 | 90923 | 38788
13015101 | 405 LHL NARVIK BLACK | 40 | 4 | 90719 | 90923 | 38789
13015101 | 405 LHL NARVIK BLACK | 40 | 4 | 90720 | 90923 | 38790
14258501 | 405 LHL BRIGHT CHROME | 40 | 4 | 90721 | 90923 | 90645
14818201 | 405 LHL BRIGHT ATLAS | 40 | 4 | 90722 | 90923 | 85978
14818201 | 405 LHL BRIGHT ATLAS | 40 | 4 | 90723 | 90923 | 85979
14818201 | 405 LHL BRIGHT ATLAS | 40 | 4 | 90724 | 90923 | 85980
14818201 | 405 LHL BRIGHT ATLAS | 40 | 4 | 90725 | 90923 | 85981
14818201 | 405 LHL BRIGHT ATLAS | 40 | 4 | 90726 | 90923 | 85982
EMPTY |  | 0 | 4
EMPTY |  | 0 | 4
EMPTY |  | 0 | 4
Total for Pallet |  | 12 | Linked: 0 | Unlinked: 3
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90730 | 91451 | 43645
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90731 | 91451 | 43644
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90732 | 91451 | 43674
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90733 | 91451 | 43660
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90734 | 91451 | 43649
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90735 | 91451 | 45994
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90736 | 91451 | 45993
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90737 | 91451 | 46000
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90738 | 91451 | 45999
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90739 | 91451 | 45998
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90740 | 91451 | 45997
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90741 | 91451 | 45996
13015501 | 405 N/L NARVIK BLACK | 40 | 5 | 90742 | 91451 | 43646
14469701 | 405 N/L BRIGHT CHROME | 40 | 5 | 90743 | 91451 | 40850
14469701 | 405 N/L BRIGHT CHROME | 40 | 5 | 90744 | 91451 | 40851
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90745 | 91451 | 40864
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90746 | 91451 | 40865
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90747 | 91451 | 40866
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90748 | 91451 | 40867
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90749 | 91451 | 40870
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90750 | 91451 | 40869
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90751 | 91451 | 40868
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90752 | 91451 | 85984
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90753 | 91451 | 74683
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90754 | 91451 | 74679
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90755 | 91451 | 74678
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90756 | 91451 | 74674
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90757 | 91451 | 74675
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90758 | 91451 | 74676
14818501 | 405 N/L BRIGHT ATLAS | 40 | 5 | 90759 | 91451 | 74677
EMPTY |  | 0 | 5
EMPTY |  | 0 | 5
Total for Pallet |  | 32 | Linked: 0 | Unlinked: 2
13015301 | 405 RHL NARVIK BLACK | 40 | 6 | 90762 | 90906 | 46226
13015301 | 405 RHL NARVIK BLACK | 40 | 6 | 90763 | 90906 | 46225
13015301 | 405 RHL NARVIK BLACK | 40 | 6 | 90764 | 90906 | 46228
13015301 | 405 RHL NARVIK BLACK | 40 | 6 | 90765 | 90906 | 46227
13015401 | 405 RHL SHADOW ATLAS | 40 | 6 | 90766 | 90906 | 48968
13015401 | 405 RHL SHADOW ATLAS | 40 | 6 | 90767 | 90906 | 48972
13015401 | 405 RHL SHADOW ATLAS | 40 | 6 | 90768 | 90906 | 48971
13015401 | 405 RHL SHADOW ATLAS | 40 | 6 | 90769 | 90906 | 48970
13015401 | 405 RHL SHADOW ATLAS | 40 | 6 | 90770 | 90906 | 48977
14818401 | 405 RHL BRIGHT ATLAS | 40 | 6 | 90771 | 90906 | 45928
14818401 | 405 RHL BRIGHT ATLAS | 40 | 6 | 90772 | 90906 | 45927
EMPTY |  | 0 | 6
Part | Description | Quantity | Pallet | Shipping Label | Master [NAME] | Internal Label
32806310 | STRA205 OBSIDIAN BLK | 22 | 7 | 90774 | 92481 | 86018
32806310 | STRA205 OBSIDIAN BLK | 22 | 7 | 90775 | 92481 | 86034
32806310 | STRA205 OBSIDIAN BLK | 22 | 7 | 90776 | 92481 | 86016
32806310 | STRA205 OBSIDIAN BLK | 22 | 7 | 90777 | 92481 | 86017
32806310 | STRA205 OBSIDIAN BLK | 22 | 7 | 90778 | 92481 | 86013
32806310 | STRA205 OBSIDIAN BLK | 22 | 7 | 90779 | 92481 | 86015
32806310 | STRA205 OBSIDIAN BLK | 22 | 7 | 90780 | 92481 | 86033
32806310 | STRA205 OBSIDIAN BLK | 22 | 7 | 90781 | 92481 | 86032
32806310 | STRA205 OBSIDIAN BLK | 22 | 7 | 90782 | 92481 | 86047
32806310 | STRA205 OBSIDIAN BLK | 22 | 7 | 90783 | 92481 | 86031
32806320 | STRA205 CAVANSIT BLU | 22 | 7 | 90784 | 92481 | 74076
32806320 | STRA205 CAVANSIT BLU | 22 | 7 | 90785 | 92481 | 74061
32806320 | STRA205 CAVANSIT BLU | 22 | 7 | 90786 | 92481 | 74077
32806320 | STRA205 CAVANSIT BLU | 22 | 7 | 90787 | 92481 | 85985
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90788 | 92481 | 86053
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90789 | 92481 | 86048
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90790 | 92481 | 86050
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90791 | 92481 | 86052
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90792 | 92481 | 86054
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90793 | 92481 | 86046
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90794 | 92481 | 86049
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90795 | 92481 | 86051
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90796 | 92481 | 86092
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90797 | 92481 | 86093
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90798 | 92481 | 86094
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90799 | 92481 | 86095
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90800 | 92481 | 86098
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90801 | 92481 | 86100
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90802 | 92481 | 86090
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90803 | 92481 | 86091
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90804 | 92481 | 86096
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90805 | 92481 | 86097
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90806 | 92481 | 86099
32806350 | STRA205 POLAR WHITE | 22 | 7 | 90807 | 92481 | 86109
32806380 | STRA205 HYACINTH RED | 22 | 7 | 90808 | 92481 | 86014
32806380 | STRA205 HYACINTH RED | 22 | 7 | 90809 | 92481 | 86012
32806380 | STRA205 HYACINTH RED | 22 | 7 | 90810 | 92481 | 86010
32806380 | STRA205 HYACINTH RED | 22 | 7 | 90811 | 92481 | 86011
32806810 | STRA205 GRAPHIT GREY | 22 | 7 | 90812 | 92481 | 86009
32806810 | STRA205 GRAPHIT GREY | 22 | 7 | 90813 | 92481 | 85992
32806810 | STRA205 GRAPHIT GREY | 22 | 7 | 90814 | 92481 | 85991