I have a table like this (2D Table)::
================================
D1 L1 Values
==================
0.1 - 1 - 0.050
0.1 - 2 - 0.055
0.1 - 3 - 0.090
0.4 - 1 - 0.060
0.4 - 2 - 0.072
0.4 - 3 - 0.099
0.7 - 1 - 1.0
0.7 - 2 - 1.1
0.7 - 3 - 2.0
2.9 - 1 - 4.0
2.9 - 2 - 5.2
2.9 - 3 - 7.0
Now I need to find a value at D1=1.5 & L1=2 point, can anyone give me a solution to do in excel?
The table which is plotted is arbitrary but in actual case it might be monotonous in nature. But linear extrapolation will be good enough to find the desired value for D1 and L1 point.
Bookmarks