How to query a matrix for multiple values and receive value

Question

I have two values

• Length
• Weight

I am looking for a solution to the problem below:

Using the input values for length and weight, locate the next higher value for each in the matrix, and then take the value from the value column. Additionally, I want to create a fallback and always use the value 1.0 if there is no upper value for my input.

How to solve this?

I have a matrix that has these values inside:

Answer 1

Try:

=IFERROR(INDEX(SORT(SORT(FILTER(MATRIX, (LENGTHS>length)*(WEIGHTS>weight)),1,1),2,1),1,3),1)

, where MATRIX, LENGTHS, and WEIGHTS refer to the data on the right, whilst length and weight refer to the cells containing 80 and 450.

Just saw you said H6 was what I referred to as length - if so:

=IFERROR(INDEX(SORT(SORT(FILTER(K6:M11, (K6:K11>H6)*(L6:L11>H7)),1,1),2,1),1,3),1)

in H8.