CODEWITHSUNDEEP
excelindexingmatchformula
ThiBu
ThiBu

Reputation: 3

Index and match approximate in row and column formula not working

I have a table. In column "A" there are heights, and in row "2" there are widths. The initial input for width and height are given by the user. And the output should be a given length.

The code I have is =INDEX(B3:Z16;MATCH(H20;B2:Z2;1);MATCH(H21;A3:A16;1))

For some reason the formula outputs a seemingly random cell in the table.

What I try to do is to let the user input dimensions and then if needed approximate the 1st lower value to give the corresponding length.

What am I doing wrong?

Table used: enter image description here

Upvotes: 0

Views: 53

Answers (1)

Andrew Doroshenko
Andrew Doroshenko

Reputation: 261

I think this should work:

=INDEX(B3:Z16;MATCH(H21;A3:A16;-1);MATCH(H20;B2:Z2;1))

Upvotes: 2

Related Questions