Spreadsheet: 215704d1361460545-vlookup-works-up-to-row-24-then-goes-n-a-for-every-row-after-demo-included-frustrating
Sheet: Sheet1

Person1 | 41300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.0417 | 0 | 0 | 0
Person2 | 41313 | 0.72 | 9.15 | 9.88 | 4.15 | 341.82 | 7.74 | 15.92 | 0 | 0 | 365.47 | 0.9549 | 13980 | 0 | 14640 | 0.5229 | 0.8158 | 0.1316 | 0
Person3 | 41321 | 0 | 2.79 | 2.79 | 0.36 | 296 | 106 | 0 | 0 | 0 | 402 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
Person4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vlookup | Person
Person5 | 41325 | 7.74 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 20.79 | person24
Person6 | 41325 |  | 0 | 0 | 0 | 279.68 | 21.39 | 18.82 | 0 | 0 | 319.89 | 0 | 0 | 0 | 0 | 1 | 0.8929 | 0.2143 | 0
Person7 | 41313 | 341.82 | 12.04 | 12.68 | 7.89 | 225.35 | 33.69 | 18.83 | 0 | 0 | 277.87 | 0.9877 | 24000 | 0 | 24300 | 0.1563 | 0.8737 | 0.2105 | 0
Person8 | 41311 |  | 0 | 0 | 0 | 268.53 | 17.53 | 24.37 | 0 | 0 | 310.42 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.1053 | 0
Person9 | 41318 | 15.92 | 6.93 | 6.93 | 2.45 | 398.29 | 29.06 | 75.12 | 0 | 0 | 502.47 | 0 | 0 | 0 | 0 | 1 | 0.8235 | 0.3529 | 0
Person10 | 41311 |  | 0 | 0 | 0 | 343.45 | 3.05 | 22.68 | 0 | 0 | 369.18 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.0909 | 0
Person11 | 41324 | 365.47 | 9.02 | 9.02 | 2.88 | 287.85 | 38.58 | 73.31 | 0 | 0 | 399.73 | 0 | 0 | 0 | 0 | 1.0667 | 0.8846 | 0.1154 | 0
Person12 | 41318 | 0 | 11.51 | 11.51 | 2.52 | 270.79 | 9.17 | 18.72 | 0 | 0 | 298.69 | 0 | 0 | 0 | 0 | 1 | 0.931 | 0.3103 | 0
[NAME] | 41324 | 38.58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27000 | 2.0667 | 0 | 0 | 0
Person14 | 41310 | 0 | 0 | 0 | 0 | 266.37 | 26.11 | 26.26 | 0 | 0 | 318.74 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.1579 | 0
Person15 | 41313 | 0.28 | 7.61 | 7.89 | 7.1 | 258.28 | 115.89 | 31.89 | 0 | 0 | 406.06 | 0.9089 | 24540 | 0 | 27000 | 0.0625 | 0.9259 | 0.2037 | 0
Person16 | 41313 | 0.63 | 13.5 | 14.13 | 6.37 | 224.12 | 9.24 | 13.71 | 0 | 0 | 247.07 | 0.9362 | 19380 | 0 | 20700 | 0.2813 | 0.8953 | 0.2558 | 0
Person17 | 41324 | 0 | 4.06 | 4.06 | 2.71 | 577.36 | 48.36 | 88.91 | 0 | 0 | 714.64 | 0 | 0 | 0 | 0 | 1.0667 | 0.7273 | 0.1818 | 0
Person18 | 41299 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.0313 | 0 | 0 | 0
Person19 | 41313 | 0 | 180 | 180 | 0.01 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
[NAME] | 41321 | 0 | 0 | 0 | 0 | 306.9 | 46.82 | 68.43 | 0 | 0 | 422.16 | 0.8794 | 17940 | 0 | 20400 | 0.125 | 0.8235 | 0.098 | 0
Person21 | 41324 | 0 | 4.73 | 4.73 | 3.17 | 604.6 | 84.67 | 10.73 | 0 | 0 | 700 | 0 | 0 | 0 | 0 | 1.0667 | 0.8 | 0.1333 | 0
Person22 | 41259 | 287.85 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9000 | 1 | 0 | 0 | 0
Person23 | 41324 | 1.16 | 9.71 | 10.87 | 2.58 | 231.2 | 46.4 | 6.28 | 0 | 0 | 283.88 | 0 | 0 | 0 | 0 | 1.0667 | 0.84 | 0.08 | 0
Person24 | 41257 | 0 | 10.39 | 10.39 | 6.06 | 230.97 | 20.79 | 43.16 | 0 | 0 | 294.92 | 0.9346 | 21420 | 0 | 22920 | 0.2042 | 0.9206 | 0.3175 | 0
Person25 | 41311 | 0 | 0 | 0 | 0 | 191.06 | 0.76 | 7.88 | 0 | 0 | 199.71 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.0588 | 0
Person26 | 41311 | 0 | 0 | 0 | 0 | 162.56 | 8.11 | 16.44 | 0 | 0 | 187.11 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.2222 | 0
Person27 | 41305 | 0 | 10.26 | 10.26 | 6.82 | 227.57 | 39.1 | 29.03 | 0 | 0 | 295.7 | 0.9714 | 24480 | 0 | 25200 | 0.125 | 0.8429 | 0.1857 | 0
Person28 | 41299 | 0.52 | 11.08 | 11.6 | 5.78 | 244.61 | 31.11 | 19.89 | 0 | 0 | 295.61 | 0.9644 | 13020 | 0 | 13500 | 0.625 | 0.875 | 0.2656 | 0
Person29 | 41321 | 73.31 | 8.96 | 8.96 | 6.36 | 325.79 | 23.05 | 17.11 | 0 | 0 | 365.95 | 0.9627 | 21660 | 0 | 22500 | 0.0625 | 0.8772 | 0.2105 | 0
Person30 | 41311 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.0333 | 0 | 0 | 0
Person31 | 41324 | 0.33 | 6.5 | 6.83 | 3.08 | 417.9 | 29.15 | 19.9 | 0 | 0 | 466.95 | 0 | 0 | 0 | 0 | 1.0667 | 0.9 | 0.05 | 0
Person32 | 41311 | 0 | 0 | 0 | 0 | 372.45 | 41.73 | 46.27 | 0 | 0 | 460.45 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.0909 | 0
Person33 | 41313 | 0.44 | 9.24 | 9.68 | 4.54 | 278.43 | 49.07 | 42.93 | 0 | 0 | 370.43 | 0.948 | 15300 | 0 | 16140 | 0.4396 | 0.8333 | 0.1905 | 0
Person34 | 41324 | 0 | 3.75 | 3.75 | 2.93 | 652.64 | 116.09 | 182 | 0 | 0 | 950.73 | 0 | 0 | 0 | 0 | 1.0667 | 0.6364 | 0.1818 | 0
Person35 | 41313 | 0.3 | 11.6 | 11.9 | 6.64 | 229.88 | 36.36 | 19.79 | 0 | 0 | 286.04 | 0.8526 | 14580 | 0 | 17100 | 0.5 | 0.9091 | 0.3117 | 0
Person36 | 41311 | 0 | 0 | 0 | 0 | 130.28 | 6.87 | 16.78 | 0 | 0 | 153.93 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.2391 | 0
Person37 | 41311 | 0 | 0 | 0 | 0 | 413.53 | 43.76 | 3.76 | 0 | 0 | 461.06 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0 | 0
Person38 | 41321 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14400 | 1.0625 | 0 | 0 | 0
Person39 | 41311 | 0 | 0 | 0 | 0 | 192.09 | 22.43 | 2.57 | 0 | 0 | 217.09 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0 | 0
Person40 | 41324 | 0 | 7.69 | 7.69 | 3.12 | 388.21 | 42.25 | 41.79 | 0 | 0 | 472.25 | 0 | 0 | 0 | 0 | 1.0667 | 0.875 | 0.125 | 0
Person41 | 41324 | 0 | 6.35 | 6.35 | 2.68 | 406 | 31.94 | 33.71 | 0 | 0 | 471.65 | 0 | 0 | 0 | 0 | 1.0667 | 0.9412 | 0.1765 | 0
Person42 | 41321 | 0.47 | 10.49 | 10.96 | 6.39 | 234.69 | 11.33 | 44.39 | 0 | 0 | 290.4 | 0.9487 | 22200 | 0 | 23400 | 0.0625 | 0.8657 | 0.2388 | 0
Person43 | 41325 | 0 | 6.26 | 6.26 | 2.71 | 360.47 | 1.53 | 43.53 | 0 | 0 | 405.53 | 0 | 0 | 0 | 0 | 1.0667 | 1 | 0.2353 | 0
Person44 | 41321 | 0.47 | 13.01 | 13.48 | 6.38 | 206.3 | 7.6 | 18.69 | 0 | 0 | 232.59 | 0.992 | 22320 | 0 | 22500 | 0.2188 | 0.8554 | 0.2289 | 0
Person45 | 41311 | 0 | 0 | 0 | 0 | 250.05 | 12.45 | 35.77 | 0 | 0 | 298.27 | 0 | 0 | 0 | 0 | 1.0333 | 0.8182 | 0.1364 | 0
Person46 | 41206 | 0 | 8.85 | 8.85 | 1.58 | 267.57 | 21.71 | 13.07 | 0 | 0 | 302.36 | 0 | 0 | 0 | 0 | 0 | 0.8571 | 0.1429 | 0
Person47 | 41318 | 0 | 9.68 | 9.68 | 2.58 | 273.2 | 24.28 | 60.2 | 0 | 0 | 357.68 | 0 | 0 | 0 | 0 | 1 | 0.88 | 0.16 | 0
Person48 | 41206 | 0.68 | 11.31 | 11.99 | 4.42 | 201.6 | 20.68 | 69.86 | 0 | 0 | 292.14 | 0.9088 | 15540 | 0 | 17100 | 0.05 | 0.84 | 0.3 | 0
Person49 | 41313 | 0.28 | 12.65 | 12.93 | 7.11 | 227.04 | 1.94 | 24.23 | 0 | 0 | 253.22 | 0.9765 | 24900 | 0 | 25500 | 0.1146 | 0.8889 | 0.3556 | 0
Person50 | 41324 | 399.73 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.0667 | 0 | 0 | 0
Person51 | 41311 | 0 | 0 | 0 | 0 | 203.03 | 25.12 | 32.94 | 0 | 0 | 261.09 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.2727 | 0
Person52 | 41311 | 0 | 0 | 0 | 0 | 272.48 | 5.35 | 48.35 | 0 | 0 | 326.17 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.0435 | 0
Person53 | 41321 | 0 | 6.4 | 6.4 | 1.41 | 211.22 | 0 | 18.22 | 0 | 0 | 229.44 | 0 | 0 | 0 | 0 | 0 | 1 | 0.3333 | 0
Person54 | 41313 | 0 | 105.88 | 105.88 | 0.01 | 16 | 0 | 39 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
Person55 | 41321 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28800 | 1.0313 | 0 | 0 | 0
Person56 | 41325 | 0 | 0 | 0 | 0 | 171.5 | 0 | 0 | 0 | 0 | 171.5 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0
Person57 | 41321 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28800 | 1.0313 | 0 | 0 | 0
Person58 | 41318 | 0.22 | 7.24 | 7.46 | 4.56 | 342.55 | 37.64 | 90.42 | 0 | 0 | 470.61 | 0.8583 | 6180 | 0 | 7200 | 0.8421 | 0.9394 | 0.3333 | 0
Person59 | 41318 | 0 | 9.28 | 9.28 | 2.48 | 282.22 | 27.48 | 69.35 | 0 | 0 | 379.04 | 0 | 0 | 0 | 0 | 1 | 0.9565 | 0.4783 | 0
Person60 | 41318 | 0.49 | 8.88 | 9.37 | 2.03 | 298.67 | 10.06 | 88 | 0 | 0 | 396.72 | 0 | 0 | 0 | 0 | 1 | 0.8889 | 0.3889 | 0
Person61 | 41323 | 0 | 9.98 | 9.98 | 3.21 | 295.38 | 22.97 | 31.59 | 0 | 0 | 349.94 | 0 | 0 | 0 | 0 | 1.0667 | 0.9375 | 0.1875 | 0
Person62 | 41324 | 0 | 6.46 | 6.46 | 3.41 | 404.18 | 21.68 | 69.77 | 0 | 0 | 495.64 | 0 | 0 | 0 | 0 | 1.0667 | 0.7273 | 0.2727 | 0
Person63 | 41325 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Person64 | 41311 | 0 | 0 | 0 | 0 | 223.3 | 18.35 | 36.74 | 0 | 0 | 278.39 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.1739 | 0
Person65 | 41222 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Person66 | 41311 | 0 | 0 | 0 | 0 | 253.48 | 79.84 | 21.24 | 0 | 0 | 354.56 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0.12 | 0
Person67 | 41222 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Person68 | 41324 | 0 | 9.52 | 9.52 | 2.94 | 246.04 | 0.11 | 67.68 | 0 | 0 | 313.82 | 0 | 0 | 0 | 0 | 1.0667 | 0.9286 | 0.2143 | 0
Person69 | 41324 | 0 | 8.68 | 8.68 | 3 | 303.58 | 9.15 | 14.04 | 0 | 0 | 326.77 | 0 | 0 | 0 | 0 | 1.0667 | 0.9615 | 0.1538 | 0
Person70 | 41311 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.0333 | 0 | 0 | 0
Person71 | 41324 | 0.34 | 6.04 | 6.37 | 2.98 | 358.78 | 101.67 | 75.11 | 0 | 0 | 535.56 | 0 | 0 | 0 | 0 | 1.0667 | 0.7778 | 0.0556 | 0
Person72 | 41311 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.0333 | 0 | 0 | 0
Person73 | 41311 | 0 | 0 | 0 | 0 | 255.79 | 63.14 | 17.64 | 0 | 0 | 336.57 | 0 | 0 | 0 | 0 | 1.0333 | 1 | 0 | 0
Person74 | 41313 | 0 | 9.74 | 9.74 | 6.57 | 338.86 | 0.59 | 6.39 | 0 | 0 | 345.84 | 0.9823 | 23340 | 0 | 23760 | 0.175 | 0.9375 | 0.1094 | 0
Person75 | 41321 | 1.27 | 13.95 | 15.22 | 4.73 | 155.33 | 34.48 | 29.35 | 0 | 0 | 219.17 | 0.8632 | 14760 | 0 | 17100 | 0.4375 | 0.9242 | 0.1364 | 0
Person76 | 41299 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.0625 | 0 | 0 | 0
Person77 | 41321 | 0 | 12.44 | 12.44 | 7.32 | 243.98 | 3.99 | 31.52 | 0 | 0 | 279.48 | 0.9711 | 26220 | 0 | 27000 | 0.0625 | 0.9341 | 0.2967 | 0
Person78 | 41325 | 0 | 3.72 | 3.72 | 1.61 | 445.5 | 114 | 294.5 | 0 | 0 | 854 | 0 | 0 | 0 | 0 | 0 | 1 | 0.1667 | 0
Person79 | 41318 | 0 | 6.16 | 6.16 | 2.6 | 534.75 | 0.19 | 42.56 | 0 | 0 | 577.5 | 0 | 0 | 0 | 0 | 1 | 0.9375 | 0.25 | 0
Person80 | 41318 | 0 | 6.81 | 6.81 | 3.23 | 476.36 | 4.91 | 37.09 | 0 | 0 | 518.36 | 0 | 0 | 0 | 0 | 1 | 0.7273 | 0.1818 | 0
Person81 | 41321 | 0.25 | 9.42 | 9.67 | 4.03 | 283.89 | 2.26 | 45.89 | 0 | 0 | 332.05 | 0.9098 | 13920 | 0 | 15300 | 0.4688 | 0.9211 | 0.1579 | 0