Automated Interpolation Using

[@TheArtOfReason]

Very nice, clearly explained a complex functionality. Thanks

[@vahidmohammadian3632]

Thank you. Very useful interpolation method. To facilitate, I copied the final formula here: FORECAST(A3,INDEX($H$3:$H$9,MATCH(A3,$G$3:$G$9,1)):INDEX($H$3:$H$9,MATCH(A3,$G$3:$G$9,1)+1),INDEX($G$3:$G$9,MATCH(A3,$G$3:$G$9,1)):INDEX($G$3:$G$9,MATCH(A3,$G$3:$G$9,1)+1))

[@blairhurst8030]

Thank you very much for this clear, methodical, and thorough presentation of the topic. I inherited a spreadsheet to use as a reference for a hydrologic model and was stumped at the use of Forecast, Index, and Match without your helpful guide! Thank you again!!

[@arunkumar-bd9it]

Thank you
Very nice, clearly explained

[@LordPrutsikas]

Thank you sir, this is extremely valuable. I can now create my own civil engineering excel sheets....without having to buy extra software.......🙂

[@HydroMohsen]

Glad it helped!

[@Adam-vg7pu]

Works perfectly! Thanks.

[@JR-ze5ss]

Very helpful. Appreciate that.

[@HydroMohsen]

Glad it was helpful!

[@ontlametsetirelo4146]

Hello and thank you much for this. i used it at it worked 🙂. However I have several sets of data to interpolate for. That is several sets of data for known a, which will give a different output for the interpolation of a (unknown a's). How do I do this with at once for say 100 columns of known a's?

[@AAKASHSINGH-uq8cf]

Hey what if the know values are integrrs ..i have some postive values and some negative values