Matching and interpolating data
Posted by Jason on March 26, 2001 12:13 PM
It seems like no one understood what I was talking about last time.So Ill try again !!
I have a set of data as an example:
Yaw Pitch Cp13 Cp24
-35 30 6.71 0.48
-30 30 5.08 0.31
-25 30 4.15 0.18
-20 30 3.42 0.03
what I want to be able to do is say I enter a value : cp13=6.81 and cp24=0.39
I would want excel to search trough the data Ihave(which nis much more than that shown above) and return a value of yaw and pitch for these coressponding values
So for : cp13=6.81 and cp24=0.39
The returned values would be yaw = -33 pitch = 30
ie the values of cp13 and cp24 are interpolated to give approx values of yaw and pitch
Could someone please help me I have no idea where to start in Excel please!!
If anything is not clear please tell me and ill try and make it clearer!
Im sure somone some Excel expert know how to does this!!