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:

Feb 11, 2023 in Others 445 views

## 1 answer to this question.

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.

• 38,010 points

## How is it possible for DynamoDB to support both Key-Value and Document database properties at the same time

As per DynamoDB's documentation, it supports both ...READ MORE

## How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

## How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

## How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Make sure ignore privacy is selected in ...READ MORE

## How to search a file with a particular extension and a particulat string in its name?

You can easily find the file using ...READ MORE