The hardest part of writing an interpolation function in Excel is the
lookup part to locate the interval that contains X and Y. Once you've
decided which interval to look in (in this case 5<X<6, 2<Y<3), then
Jerry's formula works just fine. If you decide to look in a different
interval (X=8.5, Y=3.5), then you would need to modify the cell
references to interpolate over the correct interval. If editing the
formula each time you change intervals doesn't bother you, then this
may be the easiest approach. (IE you're using the computer between
your ears to do the lookup part).
If you want to automate it further, the easiest way is to build a new
table which uses MATCH/INDEX combinations to return the boundary values
of the interval of interest, then use JErry's formula (referencing the
new subtable) to perform the interpolation.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=492672