Interpolating values in excel

Hi,

What is required is a formula to calculate the interpolated values of a table. Please refer to the attached spreadsheet.

"TABLE 1" is the table of data.
"TABLE 2" is what is required.

When given a set of values (i.e. Required Values in TABLE 2), the interpolated values of A, B and C are required.

For example, for a value of 350, the data needs to be interpolated between 340.8 and 350.2.


Any help greatly appreciated.
Book2.xlsx
forever7Asked:
Who is Participating?
 
sbaughanCommented:
here is your answer ...
The file is already filled with the formulas
just download it and enjoy
Book2.xlsx
0
 
forever7Author Commented:
That did the trick, thank you very much.

Out of interest, I was trying to get INDEX to work? would this have been possible?
0
 
sbaughanCommented:
It could have worked in theory.
The Index, combined with a match would have given the same result.
The problem I had is that the MATCH function could find the first value "Less than" the target (using the "-1" parameter), but, who knows why, it didn't work (with the "+1" parameter) to find the first value "greater than" the target.
So I had to use the OFFSET function anyway.
0
 
forever7Author Commented:
Many thanks again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.