Spreadsheet: 716715d1612342096-vlookup-returning-zero-when-there-is-a-value-in-that-cell-forum
Sheet: BOOK2

MATERIAL | TOTAL HAND | TOTAL LOCAL | TOTAL DUTY | SEAFREIGHT RANDS | SEA-EURO TO RAND
010330092 | 19.97
011091456 | 137.36
011092133 | 53.86
011092517 | 1703.35
015130319 | 76.13
015130320 | 52.73
018290505 | 4.67
018290515 | 9.559999999999999
018291435 | 17.1
018412468 | 87.52
018591061 | 84.41999999999999
060890110 | 232.41
060890111 | 188.81
060890378 | 146.58
060890379 | 154.23
060890540 | 167.13
061331850 | 73.46
063410455 | 361.95
063410834 | 665.27
064170411 | 10.67
064531931 | 158.18
064570075 | 49.47
065616370 | 120.89
065616998 | 936.3000000000001
069450974 | 191.92
070890341 | 87.72
073410795 | 240.26
073410796 | 232.89
07373C787 | 197.8
07373D079 | 127.62
074852509 | 17.99
075340043 | 1.99
173850400 | 29.5
175550736 | 8.74
178591202 | 101
178591203 | 101
178610256 | 37.2
184931597 | 172.77
201050692 | 33.34
201050693 | 65.43
201050694 | 104.91
201050695 | 217.2
201050708 | 25.07
201050767 | 87.19999999999999
201050799 | 14.68
201050800 | 27.19
201050802 | 354.65
201050812 | 34.57
201050858 | 7.18
351050808 | 16.41
480370545 | 182.11
480370604 | 1965.58
482051081 | 192.31
482691070 | 65.08
482691074 | 66.62
483692118 | 164
483692351 | 46.7
483692658 | 725.5000000000003
485651994 | 328.73
513130256 | 472.17
513331971 | 319.9
580890520 | 332.04
583332268 | 137.81
583332269 | 137.81
586135461 | 76.33
5B0890265 | 264.06
5MP1GOG | 101.34
5P6610270 | 108.32
685615361 | 1868.6
685617416 | 850.83
688291104 | 16.7
689250118 | 826.18
690050051 | 31.64
690071880 | 545.8000000000001
690072407 | 1088.6
690072965 | 303.07
690073255 | 1043.26
690073445 | 3.96
690073972 | 521.01
690074123 | 10.88
690074396 | 354.09
690074493 | 190.99
690130542 | 484.09
690370485 | 1048.77
690392012 | 308.06
690450281 | 182.71
690450315 | 103.55
690650426 | 358.59
690650427 | 270.37
690650431 | 48.83
690750007 | 215.69
691170794 | 269.51
691290955 | 52.48
691291058 | 76.75
691330759 | 13.64
691650836 | 883.56
691651010 | 146.53
691651308 | 1060.21
691651437 | 760.39
691651815 | 522.11
691651833 | 1375.29
691652013 | 1208.78
691652248 | 4140.6
691652310 | 4205.43
691652314 | 1180.41
691652391 | 673.5699999999999
691652415 | 425.81
691652446 | 579.02
691652532 | 3415.099999999999
691652697 | 730.26
691652748 | 413.14
691652827 | 802.96
691652961 | 737.32
691653036 | 241.22
691653139 | 660.19
691653209 | 251.88
691653240 | 511.3200000000001
691653557 | 518.29
691750779 | 423.73
691941934 | 40.7
692050576 | 280.08
692051039 | 199.92
692051090 | 255.04
692172765 | 563.09
692172988 | 41.25
692173219 | 24.44
692173220 | 24.44
692532013 | 445.35
692532181 | 565.82
692532753 | 9582.25
692532851 | 4236.74
692532852 | 3710.280000000001
692532988 | 750.7199999999999
692533237 | 45.29
692533389 | 308.67
692533465 | 729.8399999999999
692533748 | 330.07
692533773 | 267.12
692533848 | 315.67
692533974 | 370.81
692534388 | 168.99
692570209 | 585.09
692970218 | 273.08
692970309 | 256.67
693110281 | 713.23
693410677 | 517.54
693410789 | 672.0799999999999
693410927 | 13.72
69373A154 | 178.9
69373A158 | 235.76
69373B245 | 177.95
69373D169 | 355.91
69373F068 | 1813.73
69373F451 | 560.77
69373G272 | 353.25
693850190 | 12.41
694091977 | 210.45
694092102 | 187.31
694092133 | 203.29
694092180 | 384.05
694092257 | 408.3200000000001
694092275 | 83.05
694092317 | 122.88
694092464 | 278.5
694170796 | 15.91
694170797 | 15.91
694170822 | 288.36
694490752 | 399.47
694490779 | 186.16
694490780 | 95.43
694490932 | 163.28
694490973 | 24.13
694570113 | 9.28
694570156 | 84.52
694975294 | 71.92
694975513 | 25.63
694975516 | 31.95
694975519 | 90.08
694975695 | 24.36
694975927 | 1294.6
694975932 | 68.84
694975951 | 9.35
694976646 | 79.58
695050528 | 148.69
695210752 | 819.59
695210977 | 30.03
695211114 | 328.07
695211165 | 82
695211191 | 2418.26
695211250 | 2363.1
695260126 | 666.45
695413262 | 611.22
695510790 | 685.5200000000001
695615740 | 203.59
695616732 | 2788.09
695616978 | 1124.38
695617144 | 695.1600000000001
695617272 | 1092.46
695617274 | 1727.12
695617546 | 348.82
695617549 | 183.6
695617663 | 2278.25
695652114 | 190.66
695770254 | 712.28
695770490 | 323.95
695770494 | 346.33
695770496 | 848.52
695790039 | 976.94
695790040 | 20.48
695790068 | 24.28
695790073 | 80.69
696050220 | 723.29
696135211 | 131.73
696138317 | 730.1199999999999
696138464 | 1355.1
696138518 | 248.54
696138566 | 265.73
696138602 | 969.51
696138603 | 703.16
696139489 | 423.3099999999999
69613A569 | 201.53
696292331 | 177.25
696292367 | 372.85
696292560 | 1115.01
696292805 | 3081.56
696293003 | 2088.19
696450321 | 367.66
696731423 | 203.88
696890779 | 332.98
697210574 | 44.42
697532190 | 1390.54
697650076 | 351.03
697690205 | 249.83
697690304 | 33.98
697760018 | 72.62
697760093 | 36.14
697870152 | 229.52
698290401 | 40.86
698412505 | 15.65
698530030 | 24.51
698590953 | 134.55
698590954 | 114.13
698591167 | 423
698731687 | 216
69877A611 | 287.02
698936458 | 1398.64
698936561 | 385.31
698936790 | 309.68
698937693 | 660.54
698973951 | 11.4
699130627 | 369.44
699250154 | 178.73
708591119 | 285.77
708591120 | 134.91
717531808 | 408.89
751610145 | 24.11
754010257 | 38.12
754130987 | 38.06
754131039 | 66.82
754131050 | 19308.93
754131307 | 7.53
754131475 | 81.9
754131712 | 108.43
754131774 | 14.51
754131794 | 16.56
754131796 | 20.41
754131861 | 1163.22
754131883 | 59.63
754131959 | 669.83
754131973 | 106.55
754132055 | 198.95
754132057 | 739.6800000000001
754132282 | 413.32
754132289 | 59.78
754132323 | 98.69
754132379 | 816.3800000000001
754132603 | 57.13
757410261 | 912.2300000000001
757850036 | 296.28
758972562 | 13.49
758973780 | 300.9
758973825 | 23.52
758974507 | 160.88
758974811 | 64.25999999999999
758975256 | 12.4
760370663 | 75.21
760390210 | 357.31
760391800 | 122.8
760391826 | 223.86
760391829 | 81.1
760391872 | 102.94
760391986 | 31.97
760391987 | 49.57
760392057 | 408.34
760392069 | 62.11
761170448 | 368.37
761170716 | 304.24
761170724 | 160.93
761170847 | 1887.48
761170855 | 116.21
761170882 | 3625.92
761170980 | 786.12
761171032 | 244.63
761171040 | 62.38
761250132 | 8.67
761810162 | 34.25
761810607 | 13
761941949 | 77.31
762172976 | 41.51
762173029 | 75.17999999999999
762173244 | 28.1
762173271 | 393.02
762173272 | 139.08
762173303 | 36.72
762173492 | 4.21
762173619 | 9.34
762173634 | 69.2
762210040 | 36.65
762770250 | 71.02
762773595 | 53.1
762810882 | 30.44
762810970 | 44.18
762811016 | 6.22
763410560 | 163.46
763410830 | 30.66
763450309 | 46.15
76373D148 | 32.96
76373F549 | 182.77
76373G563 | 141.23
76373G564 | 178.21
763850369 | 9.629999999999999
763850425 | 46.46
763870139 | 28.83
763870160 | 20.23
763930071 | 35.2
764010175 | 97.78999999999999
764010246 | 30.9
764170515 | 4.7
764570114 | 896.59
764570136 | 398.8
764931142 | 71.55
764931756 | 183.52
764972158 | 74.65
764976163 | 83.97
764976371 | 33.7
764976774 | 20.96
765450169 | 1527.1
765460174 | 60.68
765550381 | 2.74
765550766 | 28.69
765652279 | 93.50999999999999
765770433 | 180.58
766136232 | 452.85
766136382 | 394.8
766138267 | 180.55
766138548 | 199.43
766138551 | 144.52
766139274 | 32.78
766139698 | 149.7
76613A054 | 386.27
766251664 | 17.16
766330873 | 8.04
766330920 | 327.77
766331108 | 10.67
766411983 | 3.97
766412070 | 35
767410291 | 23.08
767450575 | 195.12
767531986 | 17.19
767532119 | 37.6
767532178 | 183.99
767650065 | 16.05
767690303 | 9.629999999999999
767760084 | 285.47
767970295 | 18.3
768291179 | 30.28
768414440 | 97.97
768414768 | 180.98
768452100 | 1.94
768452174 | 354.59
768452385 | 50.13
768452541 | 264.9
769210498 | 22.44
769290202 | 18.24
769450798 | 151.51
769450947 | 110.23
770370629 | 534.4399999999999
772531792 | 101.15
772532819 | 131.98
775651008 | 974.66
775651978 | 112.67
775652343 | 431.58
779210277 | 137.09
780250675 | 455.57
780250676 | 308.22
780570288 | 94.21000000000001
782372445 | 47.91
782810586 | 0.6499999999999999
783531318 | 16.71
783570973 | 554.01
783830025 | 19.77
788415682 | 23.88
792970216 | 277.08
795210596 | 63.4
795210858 | 579.74
795210945 | 251.48
795211288 | 307.74
795211363 | 550.03
805690627 | 254.32
805690631 | 561.85
805690633 | 115.61
805690635 | 87.50999999999999
805690636 | 376.9
805690732 | 132.25
806890394 | 33.97
806890624 | 2964.98
806890661 | 240.56
806890668 | 1880.71
806890681 | 135.22
806890867 | 368.5
806890892 | 226.68
806890927 | 83.82
806890931 | 377.91
806890943 | 2444.06
806891083 | 181.46
810020105 | 266.09
810020106 | 309.62
810020140 | 95.29
810930075 | 15.76
810930081 | 11.85
810930088 | 56.05
810930121 | 44.91
810930152 | 131.71
810930153 | 394.86
810930154 | 403.53
810930178 | 17.31
810930187 | 138.08
811651115 | 499.1200000000001
811651531 | 5054.49
811651793 | 1705.52
811651869 | 3655.82
811652072 | 56.87
811652168 | 286.86
811652177 | 261.45
811652180 | 980.1899999999999
811652201 | 150.38
811652424 | 425.98
811652501 | 766.07
811652665 | 1204.39
811652767 | 1359.56
811652828 | 813.4300000000001
811652937 | 353.55
811652987 | 4297.6
811730231 | 406.17
811730281 | 137.65
811730289 | 640.79
811730309 | 392.87
811730386 | 79.51
811730399 | 109.01
811770436 | 518.2900000000001
811770666 | 33.76
811770673 | 71.72
811770720 | 61.47
811913569 | 98.5
812890061 | 101.3
813900042 | 2179.46
814490636 | 43.61
814490872 | 69.85
814491195 | 10.85
816210391 | 36.69
816291323 | 506.9999999999999
816291603 | 2269.44
816291890 | 270.3
816292759 | 2663.45
816450318 | 344.67
816810066 | 50.92
816810296 | 54.05
816810310 | 125.98
816810387 | 18.79
816810428 | 55.32
816850208 | 144.95
817870165 | 170.4
817870208 | 22.79
817870217 | 28.11
817870232 | 225.76
817870253 | 52.96
818730424 | 93.16
818730616 | 1789.69
818731124 | 67.56
818731447 | 516.49
818731460 | 3589.94
818731476 | 190.37
818731539 | 585.37
818731543 | 891.16
818731555 | 23.46
818731587 | 182.05
818731588 | 94.10000000000001
818731592 | 31.24
818731663 | 18.45
818800079 | 63.07000000000001
818890140 | 175.15
818890145 | 2121.17
818890164 | 114.15
820732455 | 23.45
820732503 | 39.63
820734155 | 739.25
821291424 | 58.4
824610176 | 1273.18
824610533 | 89.29
824610797 | 188.13
824610835 | 148.68
824610914 | 52.51
844090495 | 131.26
844091541 | 127.74
844092140 | 439.51
844092166 | 129.65
844092219 | 74.58
844092382 | 98.96
844092478 | 358.96
844092588 | 174.61
848414757 | 57.76
848591173 | 281.38
848591174 | 55.7
870570537 | 64.92
870650444 | 54.94
870650446 | 93.36000000000001
870650452 | 80.91000000000001
872290007 | 42.22
872290022 | 249.07
872290121 | 190.44
872290166 | 45.02
873890796 | 37.99
874931836 | 94.48
876010018 | 69.64
877330737 | 70.12
878010084 | 175.2
878010085 | 90.74000000000001
878010092 | 345.56
878010096 | 498.01
878010103 | 38.09
878010128 | 9.8
880650259 | 523.92
880650485 | 1059.66
880650486 | 170.11
880650488 | 164.51
882410161 | 410.83
882410174 | 221.95
882410180 | 431.83
882410188 | 123.75
893850399 | 60.94
895092690 | 13.66
895092701 | 26.65
895092861 | 35.47
895092862 | 5.430000000000001
895092971 | 35.65
899371285 | 1.86
899371326 | 1.92
899371357 | 1.3
899371467 | 3.72
899371472 | 4.88
899372247 | 10.11
909010127 | 44.96
909010535 | 37.43
909010686 | 56.07
909010883 | 14.79
925030176 | 40.21
931330551 | 1417.37
931330815 | 237.63
931331044 | 764.49
931331491 | 116.26
931331603 | 67.66
931331738 | 24.36
935970006 | 235.4
948650100 | 50.8
948650112 | 62.26
948650135 | 302.25
948650205 | 1127.3
948650210 | 451.46
948650225 | 382.7
948650254 | 29.08
948650255 | 25.24
948650262 | 38.33
948800141 | 1003.5
957330460 | 159.95
957330605 | 137.02
957330607 | 299.83
957330644 | 403.87
958731417 | 415.46
958731497 | 1530.93
958731648 | 723.6800000000001
958731750 | 570.08
970170037 | 178.62
970170054 | 42.44
970170072 | 46.86
970170087 | 252.58
970170088 | 4399.28
971331445 | 1377.92
971750781 | 2896.34
971750838 | 1991.44
972130022 | 204.01
972750044 | 3735.32
973850180 | 33.18
975770040 | 8.08
975770391 | 21.21
975770407 | 120.47
ANTI-KALK1 | 2429.82
BCC02WHMEU | 1616.87
C3170P1 | 58717.29
C9MARSSA9 | 729.85
CJF01DGSA | 19831.99
CLEAN+ | 1181.14
CMPDRY | 548.3199999999999
CMPLVTR | 548.3199999999999
CMPWASHDRY | 365.66
CMS4604NR | 19430.02
CPR115S | 2103.11
CPS615NX | 635.27
CPV615NR | 700.01
CR329X | 1459.56
CVI621LWNR3 | 9813.130000000001
DEKAL | 590.6600000000001
DEO-CLEAN | 708.68
DETERLANA | 1889.83
DOSF6390X | 22705.52
DW6QSSA-1 | 27637.03
[NAME] | 9055.76
DW7QSXSA-1 | 14474.77
DWI45SA | 5621.76
DWI7QSA-1 | 310.85
DWI9QDLSA-1 | 15611.12
FAB10HRBL2 | 6438.73
FAB10HRPB2 | 4782.92
FAB10HRPK2 | 2391.45
FAB10HRRD2 | 4292.46
FAB28ROR5 | 3308.88
FAB28RWH5 | 3308.89
FAB30RPB5 | 1415.82
FAB32LCR5 | 1779.81
FAB32LWH5 | 3559.62
FAB32RCR5 | 6527.98
FAB50RRD | 19795.52
FLTKDH | 135.12
FMI120S2 | 14114.5
GELPIATTI | 5905.690000000001
HBF02BLSA | 14169.78
HBF02CRSA | 7084.879999999999
HBF02PBSA | 30890.11
HBF02RDSA | 14169.78
HMF01BLEU | 60.63
HMF01WHEU | 60.63
[NAME] | 21659.61
KATE900CEX | 41636.08
KBSF01BL | 118.03
KBSF01CR | 930.51
KBSF01PB | 930.51
KBT900VE | 2703.07
[NAME] | 22889.68
KDE600EX | 13788.11
KDE900EX | 14360.38
KITCMNDSBL | 56.78
KITCPB9X | 226.98
KITEHOBD4 | 54.05
KITFC450 | 378.89
KITFC550 | 364.39
KITFC6191 | 296.3
KITFCDD | 394.52
KITRBDD | 243.21
KLF03BLSA | 100672.38
KLF03CREU | 67829.81
KLF03CRSA | 33557.46
KLF03PBSA | 67114.92
KLF03PGSA | 33557.46
KLF03PKEU | 49409.47
KLF03RDEU | 67829.81
[NAME] | 201344.76
KLF03WHEU | 67829.8
[NAME] | 33557.46
KSEG7XSA | 3293.27
KSET61E2 | 7011.73
KTE60EX | 1931.89
[NAME] | 972.85
LSTA147SSA | 59473.35
LZ116A2 | 421.52
LZ116B | 667.27
MOE25X | 7587.34
PGF64SA | 25316.25
PGF75SA | 25990.72
PGF95SA | 18244.49
PM6912WLDR | 1557.39
PS60GHC | 31749.07
PV364LCN | 2426.8
PV364NSA | 2162.6
PV375NSA | 16420.04
PV664LCNR | 354.08
[NAME] | 6492.940000000001
PV695LCNX | 4379.11
PVL6106CN | 4757.58
PX364LSA | 3567.11
PX375LSA | 27572.64
SE264TD | 3574.64
SE384EMTD | 7168.09
SE395ETB | 19394.24
SF4102MCS | 3397.72
SF4301MX | 9175.939999999999
SF4390MCX | 5262.16
SF4604MCNR | 5984.85
SF4604WMCNR | 10436.16
SF4604WMCNX | 8702.84
SF4604WVCPNR | 1855.48
SF6101TVS1 | 10776.59
SF6102TVN | 14481.96
SF6102TVS | 1132.48
SF6381X | 2178.2
SF6385XSA | 93420.95999999999
SF6390XE | 31710.49
SF7390X | 18262.3
SFLK1 | 74.83000000000001
SFP6604NRE | 3187.78
SFP6604NXE | 4817.690000000001
SFP6604WTPNX | 47496.84
SI2641D | 2022.5
SI5322B | 1618.01
SSA60MX9 | 18974.41
SSA91MAA9 | 89436.06999999999
SSA91MAP9 | 47538.21000000001
[NAME] | 204698.49
TPKTR9 | 1770.84
TR4110GR | 1264.96
TR4110P1 | 8252.16
TR90BL9 | 1216.49
TSF01CRSA | 207636.77
TSF01DGSA | 8432.65
TSF01PBEU | 27131.92
TSF01PBSA | 188760.71
TSF01PKEU | 8719.32
TSF02DGEU | 10678.19
TSF03BLEU | 20342.5
TSF03CREU | 4068.5
TSF03PGEU | 16274
UM30 | 1676.68
[NAME] | 540.48
VSTR40-2 | 1264.55
VSTR50-2 | 864.76
WHTS914LSSA | 72782.08
ZAC3172NP | 101850.96
ZACV283NX | 3458.49
ZAFA403NX | 3458.49
ZAS7F174NP | 25951.39
ZAS7L176F2P | 99912.8
Grand Total