Pricing Matrix Width x Height

[MistyDev]

Hi All,

Thanks in advance for taking time to help

I have a pricing matrix with multiple categories WIDTH Row 1 X HEIGHT Column A (as demonstrated below)

Category_1	900	1500	3000
600	$1	$2	$3
1200	$1.50	$2.5	$3.5
1800	$3	$3.5	$4

Category_2	900	1500	3000
600	$2	$4	$6
1200	$4.50	$7.5	$10.5
1800	$9.3	$13.5	$14

Excel formula works fine, as does a google doc,

 =INDEX(Cat_1,MATCH(C2,Cat_1_D),MATCH(B2,Cat_1_W))

where I've defined table name, row and column.  Works fine!,  However, I'd like is translated to AppSheet  

Thanks for any help/suggestions in advance.  I'm opening to looking at this in any way that achieves the result I'm after. 

[Aurelien]

Hi @MistyDev 

You will need to do something like that:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Get-price-of-selected-item-based-on-item-criter...

So, for your specific case it will be:

Criteria1: Width 

Criteria2:Height