Spreadsheet: 848501d1699235990-look-up-function-to-find-closest-match-within-a-2-dimensional-table-look-up-and-match-uqls-
Sheet: Sheet1

Data A | Data B |  |  |  |  |  |  | look up fuction |  | look up function to find closest match within a 2-dimensional table (excelforum.com)
38.62 | 167 |  |  |  |  |  |  | Any value between the two table values returns the interpolated value, instead of closest match.
38.62 | 167 |  |  |  |  |  |  | Look up value | Corresponding value | Lower look up | Upper look up | Look up range | Overage | % Overage | Lower Value | Upper Value | Value range | % Over * Lower range | LV*%O*Lr
38.14 | 38.53846153846154 |  |  |  |  |  |  |  | 4.257581370592149
31.86 | 27.83333333333333 |  |  |  |  |  |  |  | 4.658074587666771
31.6 | 21.78260869565218 |  |  |  |  |  |  |  | 4.938399068529606
30.78 | 17.89285714285715 |  |  |  |  |  |  | 1.25 | 6.412480439121755
29.37 | 15.18181818181818 |  |  |  |  |  |  | 2 | 9.82482634730539
26.85 | 13.18421052631579 |  |  |  |  |  |  | 5 | 17.26007185628743
23.86 | 11.65116279069768 |  |  |  |  |  |  | 10 | 22.46561676646707
22.67 | 10.4375 |  |  |  |  |  |  | 20 | 31.22420758483034
22.21 | 9.452830188679245 |  |  |  |  |  |  | 50 | 38.36840718562874
21.16 | 8.63793103448276 |  |  |  |  |  |  | 100 | 38.62
20.24 | 7.952380952380953
20.14 | 7.36764705882353
20.11 | 6.863013698630137
19.51 | 6.423076923076923
19.16 | 6.036144578313253
17.83 | 5.693181818181817
17.65 | 5.387096774193548
17.64 | 5.112244897959183
16.8 | 4.864077669902913
16.32 | 4.638888888888888
16.19 | 4.433628318584071
15.9 | 4.245762711864407
15.75 | 4.073170731707317
15.45 | 3.9140625
15.38 | 3.766917293233083
13.96 | 3.630434782608696
13.75 | 3.503496503496503
13.26 | 3.385135135135135
13.05 | 3.274509803921569
12.71 | 3.170886075949367
12.46 | 3.073619631901841
12.38 | 2.982142857142857
12.34 | 2.895953757225433
12.29 | 2.814606741573034
11.9 | 2.737704918032787
11.46 | 2.664893617021276
11.21 | 2.595854922279793
11.15 | 2.53030303030303
10.97 | 2.467980295566503
10.88 | 2.408653846153846
10.71 | 2.352112676056338
10.57 | 2.298165137614679
10.49 | 2.246636771300448
10.49 | 2.246636771300448
10.24 | 2.150214592274678
9.98 | 2.105042016806723
9.935 | 2.061728395061728
9.893 | 2.020161290322581
9.758 | 1.980237154150198
9.538 | 1.941860465116279
9.528 | 1.904942965779468
9.321 | 1.869402985074627
9.109 | 1.835164835164835
9.059 | 1.802158273381295
9.014 | 1.770318021201413
8.899 | 1.739583333333333
8.842 | 1.709897610921502
8.765 | 1.681208053691275
8.688 | 1.653465346534653
8.676 | 1.626623376623377
8.651 | 1.600638977635783
8.484 | 1.575471698113208
8.29 | 1.551083591331269
8.26 | 1.527439024390244
8.089 | 1.504504504504505
8.047 | 1.482248520710059
8.009 | 1.46064139941691
8.005 | 1.439655172413793
7.977 | 1.419263456090652
7.931 | 1.399441340782123
7.099 | 1.380165289256198
6.99 | 1.361413043478261
6.928 | 1.343163538873995
6.839 | 1.325396825396826
6.834 | 1.308093994778068
6.664 | 1.291237113402062
6.649 | 1.274809160305344
6.493 | 1.258793969849246
6.35 | 1.24317617866005
6.083 | 1.227941176470588
6.041 | 1.213075060532688
6.005 | 1.198564593301435
5.378 | 1.184397163120567
5.323 | 1.170560747663552
5.154 | 1.157043879907621
5.148 | 1.143835616438356
5.124 | 1.130925507900677
4.999 | 1.118303571428572
4.895 | 1.105960264900662
4.877 | 1.093886462882096
4.773 | 1.08207343412527
4.718 | 1.070512820512821
4.664 | 1.059196617336152
4.654 | 1.048117154811716
4.551 | 1.037267080745342
4.332 | 1.026639344262295
4.284 | 1.016227180527383
4.24 | 1.006024096385542