I attached a sheet because it made it easier to explain. Below is a mini
representation of what I need.

B
1 2 3 4 5
-------------------
1 2 3 4 5 |1 |
2 4 6 8 10 |2 |
3 6 9 12 15 |3 | A
4 8 12 16 20 |4 |
5 10 15 20 25 |5 |

given two values, say, A=2.3 and B=3.5 find the interpolated value in
the above table. The number that should come out is - assuming
straight line interpolation between points - 8.05.

I can get the limiting numbers in the A and B axis (2 & 3 and 3 & 4
respectively) but cannot get the intersepting values (6, 9, 8 & 12).
With these second lot of numbers I can easily work out the final value
(it is simple math). I just cannot get the numbers!

Hope that is clear.


--
nelg
------------------------------------------------------------------------
nelg's Profile: http://www.excelforum.com/member.php...o&userid=27771
View this thread: http://www.excelforum.com/showthread...hreadid=472841