Hello, I have been stumped on this one all day. I have a table V values across the top columns, Y values down the side rows, R values populated in the table. If I am given V and given R, how can I go to the given V column, pick out the closest R value and return the associated Y value? I have attached the spreadsheet and look forward to any suggested solutions.

Thank you in advance for your time and expertise!



Here is the spreadsheet: Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.R.xlsx