Matrix lookup with multiple criteria

[2005natsfan]

I've been trying to write a function to solve this issue: the answers to two questions gives you a third answer based on a matrix with multiple criteria.  I've been able to solve within Google Sheets and Excel using Index, Match, Match however this does not seem to work in AppSheet.  

Here is my matrix of possible answers:

ID	FNWS	NWA1	NWA2	NWA3	NWA4	NWA5
1	x	None	1-10 DB	1-10	1-30	1-100
2	None	0	0	0	0	0
3	1-10	1	2	3	3	3
4	1-30	1	2	3	4	4
5	1-100	1	2	3	4	5

I've been at this for a few days now so any help would be appreciated.  Thank You!