Multiple Intersections and interpolation

%3CLINGO-SUB%20id%3D%22lingo-sub-769360%22%20slang%3D%22en-US%22%3EMultiple%20Intersections%20and%20interpolation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769360%22%20slang%3D%22en-US%22%3EHi%2C%20I%20am%20trying%20to%20find%20an%20easy%20way%20to%20find%20the%20interpolated%20number%20within%20multiple%20intersections.%20Means%3A%20there%20are%20two%20row%20headlines%20on%20A%26amp%3BB%20and%202%20other%20topics%20on%201%26amp%3B2.%20I%20am%20trying%20to%20find%20the%20numbers%20on%20the%20intersection%20of%20A%20and%20B%20to%201%20and%202%2C%20and%20they%20have%20to%20be%20interpolated.%20See%20the%20file%20to%20have%20a%20better%20understanding%2C%20thanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-769360%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-769666%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Intersections%20and%20interpolation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769666%22%20slang%3D%22en-US%22%3ECan%20you%20please%20include%20(in%20the%20sample%20workbook%20you%20provided)%20some%20sample%20lookup%20values%20and%20the%20expected%20outcome.%20And%20which%20interpolation%20method%20do%20you%20wish%20to%20use%20(Linear%2C%20power%2C%20...)%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-769710%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Intersections%20and%20interpolation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769710%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380686%22%20target%3D%22_blank%22%3E%40Bulent_Bildik%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20know%20much%20about%20interpolation%20but%20this%20article%20seems%20to%20be%20pretty%20insightful%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.datadigitization.com%2Fdagra-in-action%2Flinear-interpolation-with-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.datadigitization.com%2Fdagra-in-action%2Flinear-interpolation-with-excel%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps!%3CBR%20%2F%3EPReagan%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770342%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Intersections%20and%20interpolation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770342%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThe%20outcome%20is%20somewhere%20in%20between%20the%204%20given%20values'%20intersection.%20Simply%2C%20if%20the%20entry%20value%20perfectly%20matches%20with%20the%20chart%20values%2C%20let's%20say%20Weight%20360%2C%200%20OAT%20to%20Speed%20of%2080%20and%20Alt%200%2C%20the%20value%20is%2022.1%20(top%20left%20first%20value)%3C%2FP%3E%3CP%3EBut%20normally%20the%20entries%20are%20not%20on%20the%20chart%2C%20but%20in%20between%20the%20chart%20values%2C%20which%20has%20to%20be%20interpolated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-771166%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Intersections%20and%20interpolation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-771166%22%20slang%3D%22en-US%22%3EHow%20do%20you%20propose%20we%20interpolate%20between%20two%20categories%2C%20first%20for%20a%20Weight%20of%20343%20which%20is%20somewhere%20around%20row%2013%20of%20the%20table%20and%20then%20for%20an%20OAT%20of%2017%2C%20which%20may%20be%20in%20various%20places%20in%20the%20same%20table.%20What%20if%20OAT%20equals%20330%20and%20Speed%20equals%2015%2C%20which%20row%20would%20you%20pick%3F%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable
Hi, I am trying to find an easy way to find the interpolated number within multiple intersections. Means: there are two row headlines on A&B and 2 other topics on 1&2. I am trying to find the numbers on the intersection of A and B to 1 and 2, and they have to be interpolated. See the file to have a better understanding, thanks
4 Replies
Highlighted
Can you please include (in the sample workbook you provided) some sample lookup values and the expected outcome. And which interpolation method do you wish to use (Linear, power, ...)?
Highlighted

Hello @Deleted,

 

I do not know much about interpolation but this article seems to be pretty insightful:

https://www.datadigitization.com/dagra-in-action/linear-interpolation-with-excel/

 

Hope this helps!
PReagan 

Highlighted

@Jan Karel Pieterse The outcome is somewhere in between the 4 given values' intersection. Simply, if the entry value perfectly matches with the chart values, let's say Weight 360, 0 OAT to Speed of 80 and Alt 0, the value is 22.1 (top left first value)

But normally the entries are not on the chart, but in between the chart values, which has to be interpolated.

Highlighted
How do you propose we interpolate between two categories, first for a Weight of 343 which is somewhere around row 13 of the table and then for an OAT of 17, which may be in various places in the same table. What if OAT equals 330 and Speed equals 15, which row would you pick?