Good Morning, long time since I've been on this forum but I'm hoping someone might have an answer for me that I've not yet managed to think of.

I have attached a simple matrix.

The problem is quite a simple issue really...I have a matrix containing differing values. Based on the column and row values inputted, I need to return the upper value from the matrix.

For example if the COLUMN value inputted is 450 then upper column value is 600, then if the ROW value inputted is 1250 then the upper row value is 1800. The two values of 600 and 1800 are then the coordinates used in the matrix to return the final result of 81.60

I've successfully used a system of columns and nested IF formulas to return the result of 81.60, however I'd like to understand if there is a more straightforward method for returning the final value. Given that the manual process of looking up the final value is quite simple, I'm sure there must be a more simple method of pulling the final value in Excel using some clever formula.

Any help would be very much appreciated. Thanks

Capture.JPG

Matrix Spreadsheet.xlsx