For a more detailed explanation of how to use INDEX and MATCH, seethis article.
you’ve got the option to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
Risk Matrix Example
To set up a simple risk matrix, you can use a formula based on INDEX and MATCH. In the example shown, the formula in J7 is: =INDEX(C5:G9,MATCH(impact,B5:B9,0),MATCH(certainty,C4:G4,0)) Where "impact" is the named range J6, and "certainty" is the named range J5 Context A risk matrix is used for risk assessment. One axis is used to assign the probability of a particular risk and the other axis is used to assign consequence or severity. A risk matrix can a useful to rank the potential impact of a particular event, decision, or risk. In the example shown, the values inside the matrix are the result of multiplying certainty by impact, on a 5-point scale. This is a purely arbitrary calculation to give each cell in the table a unique value.
