i am trying to use match to get upper and lower values of the horizontal and vertical data but i am only able to get the lower data and not the upper data.
The purpose of getting upper and lower data is to prorate them and get the pro-rated value from 4 value. (upper & lower value of x-axis AND upper & lower value of y-axis)
having the 4 values and prorate accordingly and now it seems like i am able to only get one value instead of all the 4 value to prorate.
Attached is the excel sheet for reference.