Getting values of scatter

**thegersom** · 10-21-2009, 06:41 AM

I made a scatter plot with lineair interpolation connecting the dots.

Can I get the value of those points between two points I have in my table. The function TREND is not what I need because it interpolates using all the given data. What I need is the interpolated value of the nearest point left and right for a given x.

A trendline is not an option because the data serie is not exponential or polynomial.

**zbor** · 10-21-2009, 06:45 AM

Can you uplaod example?

**thegersom** · 10-21-2009, 08:04 AM

Yes I can!

**Andy Pope** · 10-21-2009, 08:30 AM

If I understand your problem then you need to use VLOOKUP, INDEX and MATCH to determine the X values.

If not post back an example set of values to help explain what you mean.