Spreadsheet: 832874d1686650200-vlookup-returning-n-a-even-though-data-exists-excelformat
Sheet: Tab2

ID | Sales
BHXZ7W1 | -165.86
B09DHL9 | 185.99
BFY1TC8 | 10.81
BKDRZ13 | -158.43
BKF1H51 | -481
BJVLZF4 | -511.66
BF2JW03 | -162.56
BJDS7L3 | -1029.54
BJ7WGS1 | -12.25
4779209 | -45.35
BKTPD39 | 794.88
4012346 | 565.99
BK8PG20 | -75.01
BG0SC10 | 507.38
BD9PFL2 | -42
BL4SFK1 | -35.35
BMC4ZZ3 | -33.08
[NAME] | 5.6
BMTVQK9 | 520.47
BLRB262 | -477.78
BMT6455 | 602.33
BMD8F98 | -129.04
BN4N9C0 | -619.37
BL5C4C7 | -28.09
BLF7T27 | -103.66
BNTJ0F3 | 0.11
BNZGVV1 | 58.49
5934364 | 22.4
4402839 | 509.6
BF0LBX7 | -171.56
B037JC2 | -2349.1
[NAME] | 371.89
B05M8B7 | -30.21
B0LMF87 | 19.4
BKDPJX7 | -341.64
[NAME] | 422.1
BD1NML3 | 511.23
B0M7KJ7 | -618.4
B0R7JF1 | -2628.22
B11Y3K8 | 2.76
B11ZRK9 | 455.12
B11Y568 | 17.69
B0Z5YZ2 | -125.39
B164FY1 | -245.85
B0YZ0Z5 | -17.57
B1FHFF2 | -281.76
B1G5FB1 | 710.84
B1FQQK1 | -217.56
B1HKRM0 | -29.08
B1JB4K8 | 574.6
BJV2FV3 | -226.4
B1P76L5 | -36.45
B12DGD8 | 19.35
B1VP0K0 | 45.86
B1VP947 | 155.25
B17R248 | 164.04
B292JQ9 | -28.77
BL5BYR9 | 0.39
B1Z95S1 | 175.51
B1DXPB8 | 28.6
B28DTJ6 | 315.76
B28XLF6 | -5.6
B28SK09 | 64.96
B13G625 | 46.28
B3B20H2 | 36.48
B04Q047 | -50.59
B06L8P7 | 5.35
B0WFY22 | 190.1
B1GK6W4 | 148.12
7028704 | -240.61
7078066 | -76.83
7127474 | -142.7
BM67JB2 | -5.59
BF2JW25 | -24.49
BFY64L7 | 138.91
B23PWM1 | 70.44
B4VL7Q4 | -53.3
B4V2QW6 | -377.47
B4PPD31 | 125.4
B1D7R92 | -218.3
BFYG8K4 | 264.04
BYVQYG8 | 305.09
B4YVF56 | 6.18
B62G1B5 | 707.89
B3S3S52 | -1.1
B07Q2V5 | 207.82
B50LF68 | -1408
B58C6H1 | -12.2
B4RLNR1 | 1.62
BKT7807 | -58.76
B59DTF2 | -83.34
B8K9X70 | 734.35
B8F0TD6 | 424.67
B7VG6L8 | 219.25
BD4TZK8 | 149.29
[NAME] | -247.73
B5MKD81 | 91.82
B5ZQ9D3 | 21.46
B7VQL46 | 222.13
BB22L96 | 447.4
BBJPFY1 | -527.2
5129074 | -5.48
5842359 | 202
BM8H5Y5 | 451.28
4617859 | -127.83
4627193 | 783.49
5041413 | 857.63
5064722 | 52.46
BMZ4R21 | 130.1
5253973 | 16.22
B08V9H4 | 248.21
4031976 | 41.13
B91N141 | 34.92
4818351 | 175.06
4741844 | -402.51
5962332 | -6.6
5740806 | 214.86
5993901 | -130.07
4017017 | 312.41
5481558 | -34.56
4344072 | -20.64
5838057 | 24.6
5633616 | -371.99
B1LB9P6 | 682.03
4511809 | -15.78
7742468 | 992.06
4409205 | -534.85
[NAME] | -1.87
BN573R4 | 1147.96
BD814R0 | 274.05
5165294 | -4.14
BG0SCK9 | 36.8
5769209 | 372.51
B929F46 | -14.15
5990623 | 1394
[NAME] | -12.34
5092336 | -47.25
5956078 | -18.62
5948451 | 650.47
[NAME] | 41.29
BCZXZQ8 | -107.13
5075036 | -494.8
BDX86M5 | 32.9
BN0TYP0 | -303.22
5970982 | -131.03
4061393 | -368.34
B1VV9V2 | -129.42
4741714 | 20.13
5119901 | 67.78
7119868 | -56.27
5545670 | 86.51
BH3H6B9 | -59.66
5770911 | 18.42
BYR4KP7 | 10.82
4495044 | -9.6
5932409 | -1248.63
5922961 | -72.71
BJYRDP5 | -18.95
5250640 | -311.65
BDCSG82 | 969.54
5497168 | -250.66
5927353 | -866.04
7399369 | 348
BKF1Y61 | 233.18
5889505 | 186.82
7390113 | -1807.41
4942904 | 372.07
5910609 | 165
5763201 | 284.9
BP2B2B0 | -37
5636927 | -5.11
5784462 | 1841.28
BN40H61 | -3002.98
5671519 | 222.24
BNBNSG0 | -1986.13
BNFWV75 | -37.09
BNFWR44 | 68.86
BNCBD46 | 1043.63
BNLPTL8 | 371.75
BNG8PQ9 | -753.9
5881857 | 79.02
5260768 | -1738.9
4554406 | -9.23
B1SK0S6 | -175.12
5727973 | -121.74
5558203 | 3.13
B1WFDQ6 | -266.05
4846288 | 300.28
B54C017 | 592.47
4768962 | -14.65
5811917 | -1.9
5808845 | 51.42
BQV0SV7 | -56.38
5334588 | 85.35
5695423 | 2668.44
5228658 | 0.11
BSHYK55 | -25.86
7101069 | -47.37
BNC3GJ8 | 480.39
7309283 | 55.28
5809428 | -83.3
5772627 | 993.67
5769470 | -111.12
BVSS790 | 320.14
5294121 | 212.22
7582556 | 1070.29
5720273 | -1394.29
4557104 | 5.01
5287488 | -16.96
7130836 | 163.93
B156T57 | 297.38
5709948 | -1884.28
5699287 | -74.69
BYZZ7S4 | -194.34
BYY5978 | -424.16
BYZFYS3 | -33.56
4557847 | -13.36
BQJXXT1 | 1973.16
BYM6917 | -46.23
5689857 | -1029.47
B6YT190 | -38.06
5120679 | -81.33
5108664 | -64.35
BFRSRR7 | -273.31
[NAME] | -35.79
5002465 | -71.34
5076705 | 993.98
BYT9340 | 348.54
BYTBWY9 | 78.74
BZBWTJ1 | -131.57
B12W5Y9 | -2.05
B1Y47Y7 | 1619.5
BD0Q398 | -137.12
5117381 | 54.41
B1W8P14 | 40.82
BZ57390 | -49.49
7136663 | 70.36
BNHRG73 | 21.62
BNHRG84 | -618.79
5927375 | 317.2
4352097 | 34.26
4948623 | -111.67
BF0CK44 | 449.6
5800034 | 24.31
4457624 | -902.53
4927194 | 676.07
BYZR014 | -711.33
5946455 | -217.59
5169218 | 122.1
BYQP136 | 521.29
5986622 | 29.48
7792559 | -24.9
B0CCH46 | -219
BJ2KSG2 | 309.16
5750355 | -111.79
5529027 | 59.3
BMY7CH1 | 697.81
B90LKT4 | -148.7
4598589 | -49.67
5069211 | 10.36
B88MHC4 | 326.38
5756029 | 32.01
B99L0D9 | -370.02
4572709 | 636.14
5107401 | -6.66
B18YF61 | -191.98
B45GRT8 | -72.76
BQWJ8J1 | -7.37
BQQ3P21 | -952.43
7249442 | 18.26
B18YFB6 | 146.29
B5P2Z55 | 162.44
B1WLM78 | -298.14
B1N9M60 | 3.33
[NAME] | -84.36
BN57501 | 207.09
B0R47P8 | -268.47
B0R4714 | -109.02
B2NHWJ4 | -275.62
B0R47S1 | -11.72
B0R40Y8 | 355.45
B1W7F11 | -70.82
B068085 | -4.39
B068052 | -261.93
B0R47M5 | 25.2
B2422T8 | 20.72
B18YF72 | 32.64
B01S927 | 24.57
BLWDYR8 | -26.83
B1TS8Z2 | 88.74
5267639 | -267.7
BD980H2 | 180.46
5086577 | 62.24
5231485 | 162.2
BZ04NV8 | -309.4
BD97ZR4 | -3.82
B13X013 | 1265.48
7262610 | 234.42
BYZJ0B0 | 23.05
BD6S9Q7 | -158.42
BYY7VY5 | 165.26
BYY8LS2 | -198.96
BD4D942 | 1612.8
BD9Y9B7 | -86.89
BD9PNF2 | -4.67
BLGWF90 | 95.05
BDC5ST8 | 176.94
4916039 | 39.17
B15C557 | -762.5
4162791 | 408.12
5997118 | 9.06
4834108 | -106.84
5653487 | -60.42
7062713 | 438.8
B1XH026 | -652.51
BZ6CZ43 | -7.43
BZ6T5C2 | -390.93
4031879 | -24.39
4792132 | 189.05
5633962 | -10.53
[NAME] | -148.16
5623662 | -152.39
5671735 | -117.71
BYQ7HZ6 | -13.9
BYYH7G9 | 140.38
B058TZ6 | -33.24
4012250 | 313.77
5505072 | 210.87
5569711 | 95.53
4682329 | -956.13
BKDWSH5 | -440.66
BPBPJ01 | -39.75
7154104 | 0.01
5138638 | -1.67
BNDPYV1 | 108.74
B0C2CQ3 | -98.7
B4Y0230 | -622.84
4057808 | -288.48
5413700 | -30.77
B0VTWY3 | -14.08
4061412 | 33.16
7745638 | -139.56
4821638 | -5.59
B011GL4 | -127.19
5499238 | 20.4
4433839 | -166.87
5523881 | -494.61
BYZ2QP5 | 28.35
7042395 | -399.36
7212477 | -49.35
4400446 | -27.06
[NAME] | 339.43
4943510 | 85.05
5491966 | 214.72
4834777 | -12.27
5734672 | -124.3
5617096 | 28.32
5130861 | 11.01
BYVFMG1 | 8.3
5608915 | -786.31
7088429 | -142.09
7380482 | 499.44
5021318 | -72.08
4712798 | 12.03
4178419 | 48.89
5485527 | -78.92
[NAME] | -116.73
4380429 | 12.84
5641567 | 3.6
4163437 | 63.2
B0DJ8Q5 | -1047.23
5481202 | -622.13
5468346 | 29.67
4002121 | -314.11
B51PVR2 | -49.6
5843329 | 463.06
7309681 | 557.47
B1Y9TB3 | 1.21
5367227 | 3.49
5298781 | 50.71
BMT9L19 | -405.73
5355437 | 29.82
B1YXBJ7 | -1495.94
5852842 | -124.13
BCZM1B2 | 79.73
BYTK8S2 | -95.2
5465358 | -75.74
7107551 | -11.08
5176177 | 82.57
BDT88L2 | -442.65
B06CF71 | -250.34
7058228 | -17.99
7021963 | -369.39
7017586 | -490.19
B1L3CS6 | 0.79
4754972 | 90.95
7622043 | 246.25
5999330 | -185.06
4457088 | -26.24
5735631 | -163
BZBY737 | -1111.91
5716302 | 3070.2
BYXS699 | 510.19
BD3DW55 | 67.49
BDRJ2B5 | -344.53
BYW82K3 | 37.25
BD97P41 | 19.66
BF03BV1 | -59.61
BZCNB42 | 99.3
BD6QT83 | 61.27
BDC3R17 | -289.8
5802449 | -14.68
[NAME] | -12.38
BYWH8S0 | -71.69
BDZRDG3 | 10.63
BFYTTC2 | -830.08
BFYXP82 | 558.72
BFMBLM4 | -55.83
BG0SJ42 | -23.02
BF2JTN5 | 456.01
BF2JVY0 | 182.84
BFMHVQ6 | 253.03
BF2JTR9 | -2.74
BD594Y4 | -1638.75
BFY64X9 | 10.5
BF2JTD5 | -24.99
BF2JTS0 | 251.94
BF2JTV3 | 40
BF2JSW7 | -814.17
[NAME] | -439.35
BYWLC68 | -165.03
B048Z71 | 76.51
[NAME] | -7.19
BGV7F95 | -1403.97
BQWND43 | 216.9
[NAME] | -199.73