Get value from Length & Height from pricing chart

[glenny2]

Hi, I'm looking to get pricing from the pricing chart attached below.
problem:

Value 1: (width) 1000 x (Height) 2500
the expected answer shown in the pricing cell should show as $1516

If the value inputed Value 1 (width) is 1100, it should automatically calculate as the highest value which is 1250,
If the value inputed Value 1 (Height) is 2100, it should automatically calculate as the highest value which is 2250

Screenshot 2023-03-10 203734.png

not sure if this will would. thanks!

[popipipo]

Try the combination index()match();match() formula.
For beter help upload your excelfile here.

[avk]

With Sumproduct also
attach sample file, refer yellow banner on top of page. How to attach

[glenny2]

Hi, Attached

[popipipo]

Take a look at this.

[JohnTopley]

Try

Please Login or Register  to view this content.

[glenny2]

sick, i got it.


Is there an additional way I can type in a value that is not in the table, however, it automatically calculate to the next highest value.
EG: value 1: (width) 1100 x (height) 1600

[JohnTopley]

If want the next HIGHEST price you will need to "reverse" the table as shown in the attached (R4:AD14)

Formula is (H17):

=INDEX($R$4:$AD$14,MATCH($D17,$Q$4:$Q$14,-1),MATCH($C17,$R$3:$AD$3,-1))

[avk]

"F17"

Please Login or Register  to view this content.

"F18"

Please Login or Register  to view this content.