What is the simplest way to interpolate and lookup in an x,y table in excel?
- by dassouki
I would like to do a lookup and interpolation based on x, y data for the following table. I'd like the equation to be as simple as possible to reduce the amount of possible errors. The full table is about 50 rows x 30 columns. I have about 20 of those tables. Here is an extract from one:
A B C D
1 0.1 0.2 0.3
2 2.4 450 300 50
3 2.3 500 375 52
4 2.1 550 475 55
5 1.8 600 600 60
For example, the equation should find the value for x = 2.27 and y = 0.15