Spreadsheet: 72825d1273544016-excel-2007-vlookup-w-variable-limits-and-values-ex
Sheet: Sheet1

Example |  |  |  |  |  | Actual Set
Load | Disp | NEEDED DISP |  |  |  | Load | Disp
0 | 0 |  |  |  |  | 0 | 0
10 | 1.3 |  |  |  |  | 1.09375 | 9.2204995e-05
20 | 2 |  |  |  |  | 2.90625 | 9.2204995e-05
30 | 4 |  |  |  |  | 4.46875 | 9.2204995e-05
40 | 5 |  |  |  |  | 12.15625 | 0.000369555
50 | 7 |  |  |  |  | 13.625 | 0.000462005
60 | 8 |  |  |  |  | 14.8125 | 0.00055445498
70 | 10 |  |  |  |  | 16.03125 | 0.00069288502
60 | 9.5 |  |  |  |  | 18.875 | 0.000738865
50 | 7.2 |  |  |  |  | 24.09375 | 0.00110842
40 | 7.1 |  |  |  |  | 25.25 | 0.001431505
30 | 6 |  |  |  |  | 26.59375 | 0.00161567
20 | 5.5 |  |  |  |  | 30.6875 | 0.001939245
10 | 3 |  |  |  |  | 34.71875 | 0.002492965
0 | 1 |  |  |  |  | 35.78125 | 0.002953745
-5 | -1.5 |  |  |  |  | 36.84375 | 0.0030457051
-10 | -3 |  |  |  |  | 38.78125 | 0.003414525
-15 | -4.5 |  |  |  |  | 45.21875 | 0.0041991249
-20 | -6 |  |  |  |  | 45.96875 | 0.0046139248
-25 | -7.5 |  |  |  |  | 46.96875 | 0.0048445598
-30 | -9 |  |  |  |  | 49.21875 | 0.0051676449
-35 | -10.5 |  |  |  |  | 54.8125 | 0.0060901851
-40 | -12 |  |  |  |  | 55.5625 | 0.006412535
-45 | -13.5 |  |  |  |  | 56.5625 | 0.0069200294
-50 | -15 |  |  |  |  | 57.625 | 0.0071966453
-55 | -16.5 |  |  |  |  | 64.09375 | 0.0080267349
-60 | -18 |  |  |  |  | 64.8125 | 0.0086724143
-65 | -18.25 |  |  |  |  | 65.5 | 0.0090869702
-50 | -17 |  |  |  |  | 66.21875 | 0.0094560347
-42 | -15 |  |  |  |  | 69.96875 | 0.010148184
-36 | -13 |  |  |  |  | 73.40625 | 0.01125489
-28.6666666666667 | -10 |  |  |  |  | 73.75 | 0.011854345
-21.6666666666667 | -9 |  |  |  |  | 74.46875 | 0.01231488
-14.6666666666667 | -5 |  |  |  |  | 78.96875 | 0.01314546
-7.66666666666666 | -3 |  |  |  |  | 81.09375 | 0.014021775
-0.666666666666657 | 0 |  |  |  |  | 81.34375 | 0.01471319
6.33333333333334 | 1 |  |  |  |  | 81.71875 | 0.015635485
13.3333333333333 | 4 |  |  |  |  | 83.53125 | 0.016097
20.3333333333333 | 4.5 |  |  |  |  | 88.1875 | 0.017479829
27.3333333333333 | 5 |  |  |  |  | 88.15625 | 0.018309919
34.3333333333333 | 7 |  |  |  |  | 88.40625 | 0.018863149
41.3333333333333 | 8 |  |  |  |  | 90.46875 | 0.019601036
48.3333333333333 | 12 |  |  |  |  | 92.625 | 0.020662006
55.3333333333333 | 14 |  |  |  |  | 91.21875 | 0.02144587
62.3333333333333 | 16 |  |  |  |  | 90.03125 | 0.021998856
69.3333333333333 | 18 |  |  |  |  | 89.125 | 0.022460371
76.3333333333333 | 22 |  |  |  |  | 88.3125 | 0.022921149
83.3333333333333 | 13 |  |  |  |  | 87.59375 | 0.023335705
90.3333333333333 | 26 |  |  |  |  | 86.90625 | 0.023704525
 |  |  |  |  |  | 86.34375 | 0.024027364
 |  |  |  |  |  | 85.90625 | 0.024211776
 |  |  |  |  |  | 85.4375 | 0.024488389
 |  |  |  |  |  | 84.96875 | 0.024672311
 |  |  |  |  |  | 84.59375 | 0.024856964
 |  |  |  |  |  | 84.1875 | 0.024949415
 |  |  |  |  |  | 83.84375 | 0.025087599
 |  |  |  |  |  | 83.53125 | 0.02522603
 |  |  |  |  |  | 82.90625 | 0.025502399
 |  |  |  |  |  | 74.21875 | 0.025502155
 |  |  |  |  |  | 72.03125 | 0.025363725
 |  |  |  |  |  | 70.53125 | 0.02527103
 |  |  |  |  |  | 68.78125 | 0.025225051
 |  |  |  |  |  | 61.40625 | 0.024855005
 |  |  |  |  |  | 59.875 | 0.024716329
 |  |  |  |  |  | 58.46875 | 0.024532165
 |  |  |  |  |  | 56.96875 | 0.024485694
 |  |  |  |  |  | 50.53125 | 0.02434653
 |  |  |  |  |  | 48.1875 | 0.023885259
 |  |  |  |  |  | 46.78125 | 0.023839034
 |  |  |  |  |  | 45.28125 | 0.023746829
 |  |  |  |  |  | 37.65625 | 0.023377029
 |  |  |  |  |  | 36.5625 | 0.022916004
 |  |  |  |  |  | 35.25 | 0.02263939
 |  |  |  |  |  | 33.875 | 0.022547429
 |  |  |  |  |  | 30.625 | 0.02240851
 |  |  |  |  |  | 25.21875 | 0.021486459
 |  |  |  |  |  | 24.09375 | 0.021301804
 |  |  |  |  |  | 22.8125 | 0.020978719
 |  |  |  |  |  | 21 | 0.020840045
 |  |  |  |  |  | 14.625 | 0.019963974
 |  |  |  |  |  | 13.71875 | 0.019549176
 |  |  |  |  |  | 12.625 | 0.019410744
 |  |  |  |  |  | 10.9375 | 0.01904168
 |  |  |  |  |  | 5.65625 | 0.0182111
 |  |  |  |  |  | 4.875 | 0.017750319
 |  |  |  |  |  | 4.09375 | 0.017427724
 |  |  |  |  |  | 3.09375 | 0.017335765
 |  |  |  |  |  | -3.4375 | 0.016551409
 |  |  |  |  |  | -4.28125 | 0.015998425
 |  |  |  |  |  | -5.28125 | 0.0155374
 |  |  |  |  |  | -6.53125 | 0.015168335
 |  |  |  |  |  | -12.25 | 0.014338245
 |  |  |  |  |  | -12.875 | 0.01373879
 |  |  |  |  |  | -13.625 | 0.013415949
 |  |  |  |  |  | -14.53125 | 0.01295517
 |  |  |  |  |  | -17.25 | 0.012632085
 |  |  |  |  |  | -22.1875 | 0.011433175
 |  |  |  |  |  | -22.65625 | 0.010741515
 |  |  |  |  |  | -23.53125 | 0.010511125
 |  |  |  |  |  | -27.71875 | 0.0098649543
 |  |  |  |  |  | -30.90625 | 0.0089433948
 |  |  |  |  |  | -31.5 | 0.0084361453
 |  |  |  |  |  | -32.09375 | 0.007975365
 |  |  |  |  |  | -33.28125 | 0.0075600748
 |  |  |  |  |  | -39.65625 | 0.0064998399
 |  |  |  |  |  | -40.15625 | 0.0059003849
 |  |  |  |  |  | -40.78125 | 0.005347155
 |  |  |  |  |  | -41.59375 | 0.0047939252
 |  |  |  |  |  | -45.59375 | 0.0041944701
 |  |  |  |  |  | -48.75 | 0.0030877651
 |  |  |  |  |  | -49.21875 | 0.0024885549
 |  |  |  |  |  | -49.78125 | 0.001935325
 |  |  |  |  |  | -55.28125 | 0.001012785
 |  |  |  |  |  | -56.5625 | 0.000136715
 |  |  |  |  |  | -57 | -0.00055494503
 |  |  |  |  |  | -57.46875 | -0.001338565
 |  |  |  |  |  | -60.03125 | -0.00189204
 |  |  |  |  |  | -64.5 | -0.0029987448
 |  |  |  |  |  | -64.78125 | -0.0036904048
 |  |  |  |  |  | -65.25 | -0.0043358398
 |  |  |  |  |  | -68.78125 | -0.004889315
 |  |  |  |  |  | -72.40625 | -0.006272635
 |  |  |  |  |  | -72.5625 | -0.0070562549
 |  |  |  |  |  | -73.1875 | -0.0075635049
 |  |  |  |  |  | -75.03125 | -0.0080247754
 |  |  |  |  |  | -80.40625 | -0.0092701549
 |  |  |  |  |  | -80.4375 | -0.01000804
 |  |  |  |  |  | -80.90625 | -0.01074568
 |  |  |  |  |  | -81.5625 | -0.011252929
 |  |  |  |  |  | -88.28125 | -0.012452085
 |  |  |  |  |  | -88.34375 | -0.013189235
 |  |  |  |  |  | -88.84375 | -0.013835405
 |  |  |  |  |  | -89.625 | -0.01448084
 |  |  |  |  |  | -94.78125 | -0.015587544
 |  |  |  |  |  | -93.34375 | -0.016187245
 |  |  |  |  |  | -92.5 | -0.016463615
 |  |  |  |  |  | -91.53125 | -0.016924884
 |  |  |  |  |  | -91.03125 | -0.0172015
 |  |  |  |  |  | -90.3125 | -0.017294195
 |  |  |  |  |  | -89.96875 | -0.017754976
 |  |  |  |  |  | -89.5625 | -0.017893404
 |  |  |  |  |  | -89.125 | -0.017985854
 |  |  |  |  |  | -88.71875 | -0.018215999
 |  |  |  |  |  | -88.53125 | -0.018354185
 |  |  |  |  |  | -88.125 | -0.018492613
 |  |  |  |  |  | -87.9375 | -0.018492613
 |  |  |  |  |  | -81.40625 | -0.018630799
 |  |  |  |  |  | -73.40625 | -0.018492125
 |  |  |  |  |  | -64.78125 | -0.018261245
 |  |  |  |  |  | -61.09375 | -0.017891936
 |  |  |  |  |  | -54.96875 | -0.017706545
 |  |  |  |  |  | -48.625 | -0.017152824
 |  |  |  |  |  | -44.09375 | -0.01682974
 |  |  |  |  |  | -36.65625 | -0.016137101
 |  |  |  |  |  | -31.3125 | -0.015722055
 |  |  |  |  |  | -25.4375 | -0.014891719
 |  |  |  |  |  | -22.28125 | -0.014476675
 |  |  |  |  |  | -14.59375 | -0.013461685
 |  |  |  |  |  | -11.28125 | -0.012769289
 |  |  |  |  |  | -5.21875 | -0.01161685
 |  |  |  |  |  | -3.34375 | -0.01083274
 |  |  |  |  |  | 3.96875 | -0.0097257905
 |  |  |  |  |  | 5.71875 | -0.0089414343
 |  |  |  |  |  | 13.21875 | -0.0078344848
 |  |  |  |  |  | 15.0625 | -0.0070508649
 |  |  |  |  |  | 22.15625 | -0.0057592597
 |  |  |  |  |  | 23.6875 | -0.0048369649
 |  |  |  |  |  | 31.65625 | -0.003499625
 |  |  |  |  |  | 32.90625 | -0.0026233101
 |  |  |  |  |  | 40.53125 | -0.0011472949
 |  |  |  |  |  | 41.65625 | 4.8999791e-06
 |  |  |  |  |  | 47.9375 | 0.00120479
 |  |  |  |  |  | 50.15625 | 0.0024032099
 |  |  |  |  |  | 56.46875 | 0.0039249598
 |  |  |  |  |  | 58.0625 | 0.0054924451
 |  |  |  |  |  | 61.8125 | 0.0065993951
 |  |  |  |  |  | 65.75 | 0.0085824151
 |  |  |  |  |  | 67.28125 | 0.0096888747
 |  |  |  |  |  | 73.25 | 0.011625915
 |  |  |  |  |  | 74.90625 | 0.01296301
 |  |  |  |  |  | 80.15625 | 0.014900295
 |  |  |  |  |  | 81.03125 | 0.01632935
 |  |  |  |  |  | 87.1875 | 0.018450309
 |  |  |  |  |  | 88.09375 | 0.019741423
 |  |  |  |  |  | 91.46875 | 0.021540035
 |  |  |  |  |  | 89.5625 | 0.022461839
 |  |  |  |  |  | 88.21875 | 0.023061294
 |  |  |  |  |  | 87.09375 | 0.023614034
 |  |  |  |  |  | 86.40625 | 0.023982855
 |  |  |  |  |  | 85.78125 | 0.024397898
 |  |  |  |  |  | 85.09375 | 0.02458231
 |  |  |  |  |  | 84.625 | 0.024904905
 |  |  |  |  |  | 84.15625 | 0.025089314
 |  |  |  |  |  | 83.71875 | 0.025319705
 |  |  |  |  |  | 83.40625 | 0.025457889
 |  |  |  |  |  | 83.0625 | 0.025550094
 |  |  |  |  |  | 82.71875 | 0.025688769
 |  |  |  |  |  | 82.46875 | 0.025872935
 |  |  |  |  |  | 82.1875 | 0.026057344
 |  |  |  |  |  | 73.625 | 0.025918424
 |  |  |  |  |  | 68.90625 | 0.025917934
 |  |  |  |  |  | 59.8125 | 0.02527152
 |  |  |  |  |  | 56.96875 | 0.025179069
 |  |  |  |  |  | 48.96875 | 0.024809025
 |  |  |  |  |  | 45.1875 | 0.024347264
 |  |  |  |  |  | 36.34375 | 0.023654625
 |  |  |  |  |  | 33.59375 | 0.023055904
 |  |  |  |  |  | 28.09375 | 0.022502184
 |  |  |  |  |  | 22.53125 | 0.021533664
 |  |  |  |  |  | 18.4375 | 0.020933963
 |  |  |  |  |  | 12.40625 | 0.020010933
 |  |  |  |  |  | 9.0625 | 0.01913511
 |  |  |  |  |  | 3.65625 | 0.018028405
 |  |  |  |  |  | 1.1875 | 0.017244786
 |  |  |  |  |  | -5.40625 | 0.016137835
 |  |  |  |  |  | -8.21875 | 0.015261766
 |  |  |  |  |  | -13.90625 | 0.01387869
 |  |  |  |  |  | -15.75 | 0.013094825
 |  |  |  |  |  | -22.96875 | 0.011619055
 |  |  |  |  |  | -24.65625 | 0.01065029
 |  |  |  |  |  | -31.71875 | 0.0090825595
 |  |  |  |  |  | -33.09375 | 0.008160755
 |  |  |  |  |  | -40.5 | 0.0065005748
 |  |  |  |  |  | -41.53125 | 0.0052097049
 |  |  |  |  |  | -48.375 | 0.0040110401
 |  |  |  |  |  | -49.84375 | 0.0025357599
 |  |  |  |  |  | -57.34375 | 0.00073739502
 |  |  |  |  |  | -57.59375 | -0.00055371999
 |  |  |  |  |  | -62.34375 | -0.00202949
 |  |  |  |  |  | -65.15625 | -0.0037818749
 |  |  |  |  |  | -70.53125 | -0.0053955847
 |  |  |  |  |  | -72.53125 | -0.0073318901
 |  |  |  |  |  | -76.25 | -0.0086230049
 |  |  |  |  |  | -80.09375 | -0.010697985
 |  |  |  |  |  | -82.21875 | -0.011897385
 |  |  |  |  |  | -87.78125 | -0.013833934
 |  |  |  |  |  | -91 | -0.015078826
 |  |  |  |  |  | -93.09375 | -0.016600575
 |  |  |  |  |  | -91.65625 | -0.017477136
 |  |  |  |  |  | -90.65625 | -0.017799729
 |  |  |  |  |  | -89.78125 | -0.018122815
 |  |  |  |  |  | -89.34375 | -0.018306978
 |  |  |  |  |  | -88.6875 | -0.01858384
 |  |  |  |  |  | -88.34375 | -0.018814474
 |  |  |  |  |  | -87.90625 | -0.018860456
 |  |  |  |  |  | -87.5625 | -0.019045111
 |  |  |  |  |  | -87.34375 | -0.019183295
 |  |  |  |  |  | -86.96875 | -0.019321725
 |  |  |  |  |  | -86.78125 | -0.019367706
 |  |  |  |  |  | -86.40625 | -0.019506134
 |  |  |  |  |  | -86.28125 | -0.019552115
 |  |  |  |  |  | -83.71875 | -0.019690545
 |  |  |  |  |  | -72.6875 | -0.01941344
 |  |  |  |  |  | -68.53125 | -0.019366724
 |  |  |  |  |  | -60.21875 | -0.018813249
 |  |  |  |  |  | -56.875 | -0.018628106
 |  |  |  |  |  | -47.90625 | -0.018027915
 |  |  |  |  |  | -44.90625 | -0.017797034
 |  |  |  |  |  | -35.9375 | -0.016827535
 |  |  |  |  |  | -33.0625 | -0.016597144
 |  |  |  |  |  | -24.90625 | -0.015582155
 |  |  |  |  |  | -22.59375 | -0.01516711
 |  |  |  |  |  | -14.40625 | -0.01401369
 |  |  |  |  |  | -12.28125 | -0.01323007
 |  |  |  |  |  | -5.34375 | -0.012076405
 |  |  |  |  |  | -3.53125 | -0.011431214
 |  |  |  |  |  | 3.875 | -0.01013961
 |  |  |  |  |  | 5.3125 | -0.0093562342
 |  |  |  |  |  | 11.09375 | -0.0084794294
 |  |  |  |  |  | 14.28125 | -0.0072802748
 |  |  |  |  |  | 21.90625 | -0.0060346499
 |  |  |  |  |  | 23.09375 | -0.0048362296
 |  |  |  |  |  | 26.15625 | -0.00423653
 |  |  |  |  |  | 32.125 | -0.0026688001
 |  |  |  |  |  | 36.1875 | -0.0016997901
 |  |  |  |  |  | 40.5625 | 5.2105053e-05
 |  |  |  |  |  | 42.8125 | 0.00097439997
 |  |  |  |  |  | 48.9375 | 0.002772765
 |  |  |  |  |  | 50.96875 | 0.0037872649
 |  |  |  |  |  | 56.6875 | 0.0058622449
 |  |  |  |  |  | 57.46875 | 0.006968705
 |  |  |  |  |  | 64.21875 | 0.0089517245
 |  |  |  |  |  | 64.84375 | 0.010243084
 |  |  |  |  |  | 71.34375 | 0.012087675
 |  |  |  |  |  | 72.09375 | 0.013609424
 |  |  |  |  |  | 78.28125 | 0.015546219
 |  |  |  |  |  | 78.78125 | 0.0170215
 |  |  |  |  |  | 85.3125 | 0.018912069
 |  |  |  |  |  | 85.84375 | 0.020480044
 |  |  |  |  |  | 90.46875 | 0.022094
 |  |  |  |  |  | 87.9375 | 0.023153745
 |  |  |  |  |  | 86.5625 | 0.023891386
 |  |  |  |  |  | 85.625 | 0.02439839
 |  |  |  |  |  | 84.78125 | 0.024720985
 |  |  |  |  |  | 84.21875 | 0.025136029
 |  |  |  |  |  | 83.65625 | 0.025273725
 |  |  |  |  |  | 83.125 | 0.025550585
 |  |  |  |  |  | 82.71875 | 0.025780976
 |  |  |  |  |  | 82.34375 | 0.025919404
 |  |  |  |  |  | 82.09375 | 0.026011609
 |  |  |  |  |  | 81.78125 | 0.02615004
 |  |  |  |  |  | 81.40625 | 0.026380185
 |  |  |  |  |  | 81.21875 | 0.02647239
 |  |  |  |  |  | 79.3125 | 0.026610818
 |  |  |  |  |  | 69.28125 | 0.026471656
 |  |  |  |  |  | 64.90625 | 0.026148569
 |  |  |  |  |  | 57.25 | 0.02568681
 |  |  |  |  |  | 53.90625 | 0.02554789
 |  |  |  |  |  | 45.46875 | 0.024947699
 |  |  |  |  |  | 41.875 | 0.024578635
 |  |  |  |  |  | 33.96875 | 0.023563646
 |  |  |  |  |  | 31.15625 | 0.023194823
 |  |  |  |  |  | 22.875 | 0.021949444
 |  |  |  |  |  | 20.53125 | 0.021488421
 |  |  |  |  |  | 12.875 | 0.020288775
 |  |  |  |  |  | 10.9375 | 0.019781526
 |  |  |  |  |  | 4.15625 | 0.018490165
 |  |  |  |  |  | 2.5625 | 0.01775277
 |  |  |  |  |  | -4.78125 | 0.016507391
 |  |  |  |  |  | -6.40625 | 0.015539604
 |  |  |  |  |  | -13.1875 | 0.014155795
 |  |  |  |  |  | -14.53125 | 0.013187764
 |  |  |  |  |  | -20.53125 | 0.012219245
 |  |  |  |  |  | -23.40625 | 0.01078921
 |  |  |  |  |  | -30.9375 | 0.0093599102
 |  |  |  |  |  | -31.75 | 0.0081155095
 |  |  |  |  |  | -35.84375 | 0.0069628251
 |  |  |  |  |  | -40.09375 | 0.0053028897
 |  |  |  |  |  | -41.6875 | 0.0043346151
 |  |  |  |  |  | -48.34375 | 0.0024905149
 |  |  |  |  |  | -49.9375 | 0.0012911151
 |  |  |  |  |  | -55.90625 | -0.00073739502
 |  |  |  |  |  | -56.90625 | -0.001936795
 |  |  |  |  |  | -63.3125 | -0.0039653052
 |  |  |  |  |  | -64.28125 | -0.0053024003
 |  |  |  |  |  | -70.625 | -0.0076080146
 |  |  |  |  |  | -71.375 | -0.0088986401
 |  |  |  |  |  | -78.09375 | -0.01088166
 |  |  |  |  |  | -78.84375 | -0.01226547
 |  |  |  |  |  | -85.875 | -0.01415604
 |  |  |  |  |  | -86.71875 | -0.015401175
 |  |  |  |  |  | -92.59375 | -0.016968906