Return Upper Value from Matrix based on differing criteria

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

I would reverse the order of the table so 2600 is in C2 and 400 is in N2, 3000 is in B3 and 1200 is in B6, then use this:

=IFERROR(INDEX(C3:N6,MATCH(B12,B3:B6,-1),MATCH(B11,C2:N2,-1)),"No match found")

I had similar to Ali when I first looked at this however with that formula if you have a width of 400 and a drop of 1200 it returns 81.60 rather than 55.20.

Beth.

Thank you both. This is good but I can't reverse the table (unfortunately). Is there any way the formula can be tinkered with so it returns correct value when the exact values are inputted e.g. 400x1200? Thanks in advance

Change the -1s to 0s in the formula in post #3

=IFERROR(INDEX(C3:N6,MATCH(B12,B3:B6,0),MATCH(B11,C2:N2,0)),"No match found")

Or, if you cannot reverse the table then why not reverse it with formulas on a separate hidden sheet then reference it there with the formula in post #3?

Beth.

Ah yes reversing using formulas should work - thanks again