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?