Spreadsheet: 155225d1336732886-vlookup-problem-returns-n-a-vlookup-problem
Sheet: Sheet3

Outputs
distance of initial fall | Non resovled velocity | speed m/s
0 | 0 | 0 | 0 | 0 | 0 | 19.62 | 27.6 | 27.6 | -541.5120000000001 | 541.5120000000001 | 23.27041039603728 | 23.27041039603728 | 2.372111151481884 | 0
0.1 | 1.962 | 1.40071410359145 | 3.133257378323715 | 0.9903048712391553 | 0.980703738 | 19.62 | 27.6 | 27.5 | -539.5500000000001 | 540.530703738 | 23.2493161993638 | 22.25901132812465 | 2.269012367800677 | 2.247014000734901
0.2 | 3.924 | 1.980908882306301 | 4.431095078830966 | 1.400502579790555 | 1.961407476 | 19.62 | 27.6 | 27.4 | -537.5880000000001 | 539.549407476 | 23.2282028464537 | 21.82770026666315 | 2.225045898742421 | 3.116182521341155
0.3 | 5.886 | 2.426107994298687 | 5.426960972446733 | 1.715258351969172 | 2.942111214 | 19.62 | 27.6 | 27.3 | -535.6260000000001 | 538.568111214 | 23.20707028502305 | 21.49181193305388 | 2.190806517130875 | 3.757799176057226
0.4 | 7.848000000000001 | 2.801428207182901 | 6.26651475664743 | 1.980609742478311 | 3.922814952 | 19.62 | 27.6 | 27.2 | -533.6640000000001 | 537.586814952 | 23.18591846254964 | 21.20530872007133 | 2.161601296643356 | 4.28128858748558
0.5 | 9.81 | 3.132091952673165 | 7.006176488934603 | 2.214389010539928 | 4.90351869 | 19.62 | 27.6 | 27.1 | -531.702 | 536.60551869 | 23.16474732627145 | 20.95035831573152 | 2.135612468474161 | 4.72907678096123
0.6 | 11.772 | 3.431034829318991 | 7.674881809703651 | 2.425741624328527 | 5.884222427999998 | 19.62 | 27.6 | 27 | -529.74 | 535.624222428 | 23.14355682318515 | 20.71781519885663 | 2.111907767467546 | 5.122942578288757
0.7 | 13.734 | 3.705941176003742 | 8.28981981660277 | 2.620100411434646 | 6.864926166 | 19.62 | 27.6 | 26.9 | -527.778 | 534.642926166 | 23.12234690004455 | 20.50224648860991 | 2.089933383140663 | 5.475835317037854
0.8 | 15.696 | 3.961817764612603 | 8.862190157661932 | 2.80100515958111 | 7.845629904 | 19.62 | 27.6 | 26.8 | -525.816 | 533.661629904 | 23.10111750335901 | 20.3001123437779 | 2.069328475410591 | 5.796199736493179
0.9 | 17.658 | 4.202142310774351 | 9.399772134971144 | 2.970914613717466 | 8.826333642 | 19.62 | 27.6 | 26.7 | -523.854 | 532.680333642 | 23.07986857939187 | 20.10895396567441 | 2.049842402209419 | 6.089906748541679
1 | 19.62 | 4.42944691807002 | 9.908229811030829 | 3.131618971075504 | 9.80703738 | 19.62 | 27.6 | 26.6 | -521.892 | 531.69903738 | 23.05860007415888 | 19.92698110308338 | 2.031292671058448 | 6.36123466449327
2 | 39.24 | 6.26418390534633 | 14.01235297786921 | 4.428778021079856 | 19.61407476 | 19.62 | 26.6 | 25.6 | -502.272 | 521.88607476 | 22.84482599539773 | 18.41604797431788 | 1.877272984130263 | 8.3140253316831
3 | 58.86 | 7.672027111526653 | 17.16155744577397 | 5.424123167849343 | 29.42111213999999 | 19.62 | 25.6 | 24.6 | -482.652 | 512.07311214 | 22.62903250561102 | 17.20490933776168 | 1.753813388151037 | 9.512899830754394
4 | 78.48 | 8.858893836140041 | 19.81645962206166 | 6.263237942151009 | 39.22814952 | 19.62 | 24.6 | 23.6 | -463.032 | 502.26014952 | 22.41116127111668 | 16.14792332896567 | 1.646067617631567 | 10.30971315809615
5 | 98.10000000000001 | 9.904544411531507 | 22.15547539415483 | 7.002512898952775 | 49.03518689999999 | 19.62 | 23.6 | 22.6 | -443.412 | 492.4471869 | 22.19115109452414 | 15.18863819557137 | 1.54828116162807 | 10.84185880550615
6 | 117.72 | 10.84988479201508 | 24.27010729125852 | 7.670868547954658 | 58.84222428 | 19.62 | 22.6 | 21.6 | -423.792 | 482.63422428 | 21.96893771396332 | 14.29806916600866 | 1.457499405301597 | 11.18028634679064
7 | 137.34 | 11.71921499077477 | 26.21471201286407 | 8.28548499847776 | 68.64926166 | 19.62 | 21.6 | 20.6 | -404.172 | 472.82126166 | 21.74445358384524 | 13.45896858536748 | 1.371964177917174 | 11.36738861458162
8 | 156.96 | 12.52836781069266 | 28.02470595573841 | 8.857556042159711 | 78.45629904 | 19.62 | 20.6 | 19.6 | -384.552 | 463.00829904 | 21.51762763503449 | 12.66007159287478 | 1.29052717562434 | 11.43091678202268
9 | 176.58 | 13.28834075421006 | 29.72468943309249 | 9.394856913226512 | 88.26333641999999 | 19.62 | 19.6 | 18.6 | -364.9320000000001 | 453.19533642 | 21.28838501202005 | 11.89352809879354 | 1.212388185401992 | 11.39021352513805
10 | 196.2 | 14.0071410359145 | 31.33257378323715 | 9.903048712391552 | 98.07037379999997 | 19.62 | 18.6 | 17.6 | -345.3120000000001 | 443.3823738 | 21.05664678432917 | 11.15359807193762 | 1.136962086843794 | 11.25939093015645
11 | 215.82 | 14.69081345603435 | 32.86188061980324 | 10.38640511341629 | 107.87741118 | 19.62 | 17.6 | 16.6 | -325.6920000000001 | 433.5694111800001 | 20.82232962903047 | 10.43592451561418 | 1.063804741652821 | 11.04910700837936
12 | 235.44 | 15.34405422305331 | 34.32311489154794 | 10.84824633569869 | 117.68444856 | 19.62 | 16.6 | 15.6 | -306.0720000000001 | 423.75644856 | 20.58534548070544 | 9.737099145006756 | 0.9925687201841749 | 10.76762998166711
13 | 255.06 | 15.9705979850474 | 35.72463063275252 | 11.29121277542851 | 127.49148594 | 19.62 | 15.6 | 14.6 | -286.4520000000001 | 413.9434859400001 | 20.34560114471922 | 9.054388369290711 | 0.9229753689389104 | 10.42151127716887
14 | 274.68 | 16.57347278031976 | 37.07320126229727 | 11.71744525568607 | 137.29852332 | 19.62 | 14.6 | 13.6 | -266.8320000000001 | 404.1305233200001 | 20.10299786897467 | 8.385552613288597 | 0.8547963927919059 | 10.01602993729709
15 | 294.3 | 17.15517414659496 | 38.37440904851825 | 12.12870812164263 | 147.1055607 | 19.62 | 13.6 | 12.6 | -247.212 | 394.3175607000001 | 19.85743086856908 | 7.728722746926445 | 0.7878412586061616 | 9.555496671821707
16 | 313.92 | 17.71778767228008 | 39.63291924412331 | 12.52647588430202 | 156.91259808 | 19.62 | 12.6 | 11.6 | -227.592 | 384.5045980800001 | 19.60878879686351 | 7.082312912561497 | 0.7219483091296123 | 9.043468084024706
17 | 333.54 | 18.26307750626931 | 40.85267807377382 | 12.9119957969324 | 166.71963546 | 19.62 | 11.6 | 10.6 | -207.972 | 374.69163546 | 19.35695315539096 | 6.444957358458561 | 0.656978324001892 | 8.482901358188123
18 | 353.16 | 18.79255171603899 | 42.03705893360761 | 13.28633406323956 | 176.52667284 | 19.62 | 10.6 | 9.600000000000001 | -188.352 | 364.87867284 | 19.10179763373071 | 5.815463570491143 | 0.5928097421499636 | 7.876268270147325
19 | 372.78 | 19.3075114916449 | 43.18897245566048 | 13.65041062459295 | 186.33371022 | 19.62 | 9.600000000000001 | 8.600000000000001 | -168.732 | 355.06571022 | 18.843187368914 | 5.192776744321053 | 0.529335040195826 | 7.225640656658437
20 | 392.4 | 19.80908882306301 | 44.31095078830965 | 14.00502579790555 | 196.1407476 | 19.62 | 8.600000000000001 | 7.600000000000001 | -149.112 | 345.2527476 | 18.58097811203705 | 4.575952314131502 | 0.4664579321234966 | 6.532755373027246
21 | 412.02 | 20.29827578884473 | 45.40521311206677 | 14.35088098271322 | 205.94778498 | 19.62 | 7.600000000000001 | 6.600000000000001 | -129.492 | 335.43978498 | 18.31501528746291 | 3.964134304749688 | 0.4040911625636787 | 5.799064180117574
22 | 431.64 | 20.77594763181694 | 46.47371725761132 | 14.68859497569458 | 215.75482236 | 19.62 | 6.600000000000001 | 5.600000000000001 | -109.872 | 325.6268223600001 | 18.0451329271912 | 3.356537951496621 | 0.3421547351168829 | 5.025772323147955
23 | 451.26 | 21.24288116052058 | 47.51820086796847 | 15.01871698048805 | 225.56185974 | 19.62 | 5.600000000000001 | 4.600000000000001 | -90.25200000000004 | 315.81385974 | 17.77115245953396 | 2.752435479045916 | 0.280574462695812 | 4.213868447180901
24 | 470.88 | 21.69976958403015 | 48.54021458251704 | 15.34173709590932 | 235.36889712 | 19.62 | 4.600000000000001 | 3.600000000000001 | -70.63200000000003 | 306.00089712 | 17.49288132698556 | 2.151144231076241 | 0.2192807575001265 | 3.364147731758786
25 | 490.5 | 22.1472345903501 | 49.54114905515414 | 15.65809485537752 | 245.1759345 | 19.62 | 3.600000000000001 | 2.600000000000001 | -51.01200000000003 | 296.1879345 | 17.21011140289336 | 1.552016547515839 | 0.1582075991351518 | 2.477229594099749
26 | 510.12 | 22.58583626966245 | 50.52225715160795 | 15.96818624265135 | 254.98297188 | 19.62 | 2.600000000000001 | 1.600000000000001 | -31.39200000000003 | 286.37497188 | 16.92261716992972 | 0.9544309272783611 | 0.09729163376945577 | 1.553570927882497
27 | 529.74 | 23.01608133457996 | 51.4846723373219 | 16.27236950354803 | 264.79000926 | 19.62 | 1.600000000000001 | 0.6000000000000014 | -11.77200000000003 | 276.56200926 | 16.63015361504517 | 0.3577841114971427 | 0.036471367125091 | 0.593475562159035