I'm looking for a way to find the closest similar value(in distance) above the current value(column B), and return the column next to that found value(column C) in column D.
A sort of vlookup where it finds the value closest to the search key in distance above.
Using cell D11 as a target/output example, I'd describe what I want something like this in pseudo code:
Find value B11 in B1:B10, where distance from B11 is the smallest, in this case B7, and then
return value in column C, in this case the value in C7, and output results(52,921.07) it to D11.
Have a look at the blue arrows for a visualisation. I'm want to use the same principle for the other values as well.
Any ideas how to achieve this using Google Sheets?