dejhantulip
Board Regular
- Joined
- Sep 9, 2015
- Messages
- 58
- Office Version
- 365
- Platform
- Windows
Dear all,
I was wondering if someone would be kind enough to help me with the following.
I have the following scenario:
Where I have different roads in column B and the stations (locations along the road) in column C and finally the cumulative volume to be excavated up to each station in column D.
Basically what I want is a LAMBDA function that could be called XINTERPOLATE or something like that that takes the Road and the Station as inputs.
It would output the linear interpolation of the specified road between the specified stations (if the specified station is not exactly on the list) to get the corresponding volume at said station.
So basically in the screenshot:
Using the road data in cell G4 which is road 7A, I would like the volume at station 32 (cell G5).
In this case the result should be (in cell G6) equal to 45.61 using a simple linear interpolation equation.
I thank you very much in advance!
Have a great one!
I was wondering if someone would be kind enough to help me with the following.
I have the following scenario:
Where I have different roads in column B and the stations (locations along the road) in column C and finally the cumulative volume to be excavated up to each station in column D.
Basically what I want is a LAMBDA function that could be called XINTERPOLATE or something like that that takes the Road and the Station as inputs.
It would output the linear interpolation of the specified road between the specified stations (if the specified station is not exactly on the list) to get the corresponding volume at said station.
So basically in the screenshot:
Using the road data in cell G4 which is road 7A, I would like the volume at station 32 (cell G5).
In this case the result should be (in cell G6) equal to 45.61 using a simple linear interpolation equation.
I thank you very much in advance!
Have a great one!