Matrix lookup

[raikks]

Book7
	A	B	C	D	E	F
1		Consequence
2	Likelihood	Insignificant	Minor	Moderate	Major	Severe
3	Almost Certain	Low	Medium	High	Extreme	Extreme
4	Likely	Low	Medium	High	High	Extreme
5	Possible	Low	Medium	Medium	High	High
6	Unlikely	Low	Low	Medium	Medium	High
7	Rare	Low	Low	Low	Medium	Medium
8
9	Risk level	High
Sheet1

For the matrix above, if the input-1 for likelihood is ``likely'' and input-2 for consequence is ``moderate'', what formula can i use in order to output ``high'' (in cell B9)?

 

[jasonb75]

Something like this

Book1
	A	B	C	D	E	F
1		Consequence
2	Likelihood	Insignificant	Minor	Moderate	Major	Severe
3	Almost Certain	Low	Medium	High	Extreme	Extreme
4	Likely	Low	Medium	High	High	Extreme
5	Possible	Low	Medium	Medium	High	High
6	Unlikely	Low	Low	Medium	Medium	High
7	Rare	Low	Low	Low	Medium	Medium
8
9	Likelihood	Likely
10	Consequence	Moderate
11	Risk level	High
Sheet4

Cell Formulas
Range	Formula
B11	B11	=INDEX($B$3:$F$7,MATCH(B9,$A$3:$A$7,0),MATCH(B10,$B$2:$F$2,0))

 

[raikks]

Thanks @jasonb75 - really great job!