Index and Match Help for Risk Calculation

[bw5727]

I am trying to auto populate the risk level of an item based on the selection from two fields and where they intersect in a matrix

Column A = Impact; dropdown selection
Column B = Probability; drop selection
Column C = Risk Level; calculated based on the selection in the above two fields and where they intersect in the matrix

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Impact[/TD]
[TD]Probability[/TD]
[TD]Risk Level[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Medium[/TD]
[TD]Likely[/TD]
[TD]Medium[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 522"]
<colgroup><col width="87" span="6" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 87"][/TD]
[TD="width: 87"]A[/TD]
[TD="width: 87"]B[/TD]
[TD="width: 87"]C[/TD]
[TD="width: 87"]D[/TD]
[TD="width: 87"]E[/TD]
[TD="width: 87"]F[/TD]
[/TR]
[TR]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"]Negligible[/TD]
[TD="width: 87"]Low[/TD]
[TD="width: 87"]Medium[/TD]
[TD="width: 87"]High[/TD]
[TD="width: 87"]Severe[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Almost Certain[/TD]
[TD="class: xl66, bgcolor: #FFE699"]Medium[/TD]
[TD="class: xl67, bgcolor: #FEB0AD"]High[/TD]
[TD="class: xl67, bgcolor: #FEB0AD"]High[/TD]
[TD="class: xl68, bgcolor: #C00000"]Extreme[/TD]
[TD="class: xl68, bgcolor: #C00000"]Extreme[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Very Likely[/TD]
[TD="class: xl66, bgcolor: #FFE699"]Medium[/TD]
[TD="class: xl66, bgcolor: #FFE699"]Medium[/TD]
[TD="class: xl67, bgcolor: #FEB0AD"]High[/TD]
[TD="class: xl67, bgcolor: #FEB0AD"]High[/TD]
[TD="class: xl68, bgcolor: #C00000"]Extreme[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Likely[/TD]
[TD="class: xl65, bgcolor: #A9D08E"]Low[/TD]
[TD="class: xl66, bgcolor: #FFE699"]Medium[/TD]
[TD="class: xl66, bgcolor: #FFE699"]Medium[/TD]
[TD="class: xl66, bgcolor: #FFE699"]Medium[/TD]
[TD="class: xl67, bgcolor: #FEB0AD"]High[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Unlikely[/TD]
[TD="class: xl65, bgcolor: #A9D08E"]Low[/TD]
[TD="class: xl65, bgcolor: #A9D08E"]Low[/TD]
[TD="class: xl65, bgcolor: #A9D08E"]Low[/TD]
[TD="class: xl66, bgcolor: #FFE699"]Medium[/TD]
[TD="class: xl66, bgcolor: #FFE699"]Medium[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Rare[/TD]
[TD="class: xl65, bgcolor: #A9D08E"]Low[/TD]
[TD="class: xl65, bgcolor: #A9D08E"]Low[/TD]
[TD="class: xl65, bgcolor: #A9D08E"]Low[/TD]
[TD="class: xl65, bgcolor: #A9D08E"]Low[/TD]
[TD="class: xl66, bgcolor: #FFE699"]Medium[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1084274-risk-assessment-calculation.html#post5210104

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.