Find a value within a table (horizontal and diagonal)

**fenfen** · 02-01-2013, 11:34 AM

Hi everyone,

I need help to solve my problem with finding a value in a table.

As you can refer to the table, I need to find the delivery cost which based on the distance of the delivery place and the weight of the item. Now I can find the cost if the weight is ranging between 120 kg to 150 and the distance is ranging between 80 km to 100 km, but if the weight is precisely 120 kg or the distance is precisely 80 km then it's going to be 1 cell off. Can anyone help me?

Thank you in advance.

**twiggywales** · 02-01-2013, 11:47 AM

Try...

Please Login or Register  to view this content.

**bebo021999** · 02-01-2013, 12:01 PM

In D11 should be:

Please Login or Register  to view this content.

Confirmed by holding both Ctrl-Shift, then Enter

**twiggywales** · 02-01-2013, 12:15 PM

Originally Posted by bebo021999

In D11 should be:

Please Login or Register  to view this content.

Confirmed by holding both Ctrl-Shift, then Enter

pretty much what mine does only without the CSE

if you do it the way i did then the INDEX(A2:A7>=B15,,) returns an array answer of true or false answers, then match matches the first True value, then the second index (or first as you read from the left across) uses that match in the table

**bebo021999** · 02-01-2013, 12:53 PM

Originally Posted by twiggywales

pretty much what mine does only without the CSE

if you do it the way i did then the INDEX(A2:A7>=B15,,) returns an array answer of true or false answers, then match matches the first True value, then the second index (or first as you read from the left across) uses that match in the table

Sure it is