Interpolating values in excel

Posted on 2012-08-13
Last Modified: 2012-08-14

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.
Question by:forever7
    LVL 5

    Accepted Solution

    here is your answer ...
    The file is already filled with the formulas
    just download it and enjoy

    Author Closing Comment

    That did the trick, thank you very much.

    Out of interest, I was trying to get INDEX to work? would this have been possible?
    LVL 5

    Expert Comment

    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.

    Author Comment

    Many thanks again

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Title # Comments Views Activity
    How can I run an Excel macro from a command line 6 26
    MS Excel Cell questions 5 39
    VBA filters 2 20
    Excel Averageifs 2 2
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now