Spreadsheet: 848542d1699274714-look-up-function-to-find-closest-match-within-a-2-dimensional-table-look-up-and-match-edited-
Sheet: Sheet1

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