Interpolate with Excel | FORECAST function can interpolate | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Download the example file★

★ About this video ★
Interpolation is the process of estimating data points within an existing data set, how can we do this with Excel?

It was the following question which first made me look into this topic:
“I have an Excel question – Is there a way to interpolate a value from a table? I have an X and Y that are not on the table, but have correlated data so want to calculate the interpolated value."

In terms of answering the question, there are several scenarios that would lead to different solutions.
- Simple mathematics
- FORECAST / FORECAST.LINEAR
- Inner linear interpolation

In this video, we'll look at all these scenarios.

★ Resources for more advanced techniques ★

Cell ranges: basic things 99% of users don’t know

The real reason INDEX / MATCH is better than VLOOKUP

INDEX / MATCH / MATCH

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel #ForecastFunction #Interpolate

[RomansChap]

Dude! You don't know how much this helps me! I have been using excel for over a year with over 900+ cells that I have separated into over 150 data tables. I manually forecasted all of them. My data changes every year, so this is going to help me out SO MUCH!!!

[alekseyk]

Thank you! You explained complex for me theory in a simple way!

[RetiSports]

Excellent! I use the OFFSET function in addition to MATCH and FORECAST to do exactly this, but your method of using INDEX works better and is more straightforward. Thanks!

[LenaPfeiffer-tp]

Thank you, this was incredibly helpful!!

[NFrmrsNFD]

Brilliant method and exactly what I needed!

[purohitamadithyaudaykiran]

So clear and neat . Exactly what i was looking for. Thanks a ton

[Arbitrator]

Would love to see how Xlookup simplifies the formula.

[wayneedmondson]

Hi Mark. Nice one! This is not a process that I normally need to do in my work. Nevertheless, interesting. Very well explained and easy to follow. If it ever comes up, now I know how to handle it. Thanks for sharing :)) Thumbs up!!

[stuh.]

Hi Mark thanks for the video. Interpolation is something I need to use in most of my spreadsheets (both 1D and 2D) and I have been using VBA functions for years now to get around it. I had been hoping the Microsoft would have included a function for this by now, especially with all the new functions they have released for Office365, but alas no.
Your video gave me an idea for a better way of solving this than having to use VBA, as I have never used the FORECAST function before. I have made a little tweak to your solution and instead of using the INDEX function I'm using the OFFSET function which allows you to build arrays:
=FORECAST(E2, OFFSET(A1, MATCH(E2, A2:A11, 1), 1, 2), OFFSET(A1, MATCH(E2, A2:A11, 1), 0, 2))

[michaelfang]

Great tutorial, really appreciate it!

[anushck]

Hi sir nice video but can you please make a video where we have known y value & to find x value.

[ksoday]

How did you get the new data to populate on the graph?

[chtsm]

Dear, Thank you for your video, can we make projection from Y axe value to determine the unknown equivalent value on x axe (projection on any curve)

[eshitab]

Hi! Thanks for the video. How can I find value of x's using known y's?

[AAKASHSINGH-uqcf]

Hey, what if we have a set of positive and negative numbers

[kehindeadeyeye]

Hi Mark, thanks for the explanation. I used the last long function but I keep getting an error, 'you haven't entered enough argument for this function'. I don't know how to proceed. Can you help?

[sridharkrishnappanavanerth]

Sir, can you make a complete video on GETPIVOTDATA function. thanks

[logi]

You don't explain 17.5. The video cuts off half the table, can't see it.

[HyperSquid]

BUT WHAT IF THE VALUE YOU WANT TO INTERPOALTE IS A Y-VALUE?!?! And you want to find the x-value

[mohammadosman]

Excellent. Great resource. Thanks a bunch.