Execl Lookup Matrix Formula Problem

I have written a Lookup formula to assign a risk to likelihood and consequence sores.  But the results are back to front.
Refer attached file, in which formulas are in first sheet, and matrix is in 2nd sheet.
Can you help fix.
Risk-Matrix-Lookup-Example.xlsx
gh_userAsked:
Who is Participating?
 
akbConnect With a Mentor Commented:
You have the Row and Column in the INDEX formula around the wrong way (2nd and 3rd parameter).

e.g. C2 should be:
=IFERROR(INDEX(Matrix!$C$5:$G$9,MATCH($B3,Matrix!$B$5:$B$9,0),MATCH($A3,Matrix!$C$4:$G$4,0)),"")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.