Spreadsheet: 861821d1709650297-risk-matrix-using-ranges-of-labels-risk-matrix-post-dj
Sheet: Sheet2

 | Consequences   Likelihood |  |  | Consequences | Consequences | Consequences | Consequences | Consequences
 |  |  |  | Insignificant | Minor | Moderate | Significant | Severe
 |  |  |  | 1 - Insignificant | 2 - Minor | 3 - Moderate | 4 - Significant | 5 - Severe
 | Likelihood | Likelihood | Likelihood | A - Insignificant | B - Minor | C - Moderate | D - Significant | E - Severe
 | Almost Certain | 1 - Almost Certain | A - Almost Certain | Low | Medium | High | Extreme | Extreme |  | IFERROR(XLOOKUP($G16,$E$3:$I$3,XLOOKUP($F16,$B$6:$B$10,$E$6:$I$10)),"")
 | Likely | 2 - Likely | B - Likely | Low | Medium | High | High | Extreme
 | Possible | 3 - Possible | C - Possible | Low | Medium | Medium | High | High
 | Unlikely | 4 - Unlikely | D - Unlikely | Low | Low | Medium | Medium | High
 | Rare | 5 - Rare | [NAME] | Low | Low | Low | Medium | Medium
 | Almost Certain | Severe |  |  | Almost Certain | Minor |  | [NAME] used in range H16:H240
 |  |  |  |  |  |  |  | Risks manually changed using cells B13 and C13, then copying and pasting as values.
 | Likelihood | Consequence | All Combinations |  | Likelihood (Split) | Consequence (Split) | Risk | =IFERROR(XLOOKUP($G16,$E$3:$I$3,XLOOKUP($F16,$B$6:$B$10,$E$6:$I$10)),"Labels Error")
 |  |  |  |  |  | Insignificant | Low |  | Likelihood =
 | 1 - Almost Certain | Minor | Almost Certain~Minor |  | Almost Certain | Minor | Medium
 | A - Almost Certain | Moderate | Almost Certain~Moderate |  | Almost Certain | Moderate | High |  | Consequence =
 | Likely | Significant | Almost Certain~Significant |  | Almost Certain | Significant | Extreme
 | 2 - Likely | Severe | Almost Certain~Severe |  | Almost Certain | Severe | Extreme
 | B - Likely | 1 - Insignificant | Almost Certain~1 - Insignificant |  | Almost Certain | 1 - Insignificant | Low |  | Cells E3:E5 contain: | Insignificant | 1 - Insignificant | A - Insignificant
 | Possible | 2 - Minor | Almost Certain~2 - Minor |  | Almost Certain | 2 - Minor | Medium |  | Cells F3:F5 contain: | Minor | 2 - Minor | B - Minor
 | 3 - Possible | 3 - Moderate | Almost Certain~3 - Moderate |  | Almost Certain | 3 - Moderate | High |  | Cells G3:G5 contain: | Moderate | 3 - Moderate | C - Moderate
 | C - Possible | 4 - Significant | Almost Certain~4 - Significant |  | Almost Certain | 4 - Significant | Extreme |  | Cells H3:H5 contain: | Significant | 4 - Significant | D - Significant
 | Unlikely | 5 - Severe | Almost Certain~5 - Severe |  | Almost Certain | 5 - Severe | Extreme |  | Cells I3:I5 contain: | Severe | 5 - Severe | E - Severe
 | 4 - Unlikely | A - Insignificant | Almost Certain~A - Insignificant |  | Almost Certain | A - Insignificant | Low
 | D - Unlikely | B - Minor | Almost Certain~B - Minor |  | Almost Certain | B - Minor | Medium |  | Cells B6:D6 contain: | Almost Certain | 1 - Almost Certain | A - Almost Certain
 | Rare | C - Moderate | Almost Certain~C - Moderate |  | Almost Certain | C - Moderate | High |  | Cells B7:D7 contain: | Likely | 2 - Likely | B - Likely
 | 5 - Rare | D - Significant | Almost Certain~D - Significant |  | Almost Certain | D - Significant | Extreme |  | Cells B8:D8 contain: | Possible | 3 - Possible | C - Possible
 | [NAME] | E - Severe | Almost Certain~E - Severe |  | Almost Certain | E - Severe | Extreme |  | Cells B9:D9 contain: | Unlikely | 4 - Unlikely | D - Unlikely
 |  |  | 1 - Almost Certain~Insignificant |  | 1 - Almost Certain | Insignificant | Low |  | Cells B10:D10 contain: | Rare | 5 - Rare | [NAME]
 |  |  | 1 - Almost Certain~Minor |  | 1 - Almost Certain | Minor | Medium
 |  |  | 1 - Almost Certain~Moderate |  | 1 - Almost Certain | Moderate | High |  | Matrix in cells: | E6:I10
 |  |  | 1 - Almost Certain~Significant |  | 1 - Almost Certain | Significant | Extreme
 |  |  | 1 - Almost Certain~Severe |  | 1 - Almost Certain | Severe | Extreme |  | Cells F16:F240 contain: | 15 repeating groups of Almost Certain, 1 - Almost Certain, A - Almost Certain, Likely, 2 - Likely, B - Likely, Possible, 3 - Possible, C - Possible, Unlikely, 4 - Unlikely, D - Unlikely, [NAME], 5 - Rare, E - Rare
 |  |  | 1 - Almost Certain~1 - Insignificant |  | 1 - Almost Certain | 1 - Insignificant | Low |  |  | There will 15 copies of 'Almost Certain' followed by another 15 copies of '1 - Almost Certain'
 |  |  | 1 - Almost Certain~2 - Minor |  | 1 - Almost Certain | 2 - Minor | Medium
 |  |  | 1 - Almost Certain~3 - Moderate |  | 1 - Almost Certain | 3 - Moderate | High |  | Cells G16:G240 contain: | Insignificant, [NAME], [NAME], Significant, Severe, 1 - Insignificant, 2 - Minor, 3 - Moderate, 4 - Significant, 5 - Severe, A - Insignificant, B - Minor, C - Moderate, D - Significant, E - Severe
 |  |  | 1 - Almost Certain~4 - Significant |  | 1 - Almost Certain | 4 - Significant | Extreme |  |  | These values will be pasted adjacent each of the 15 groups
 |  |  | 1 - Almost Certain~5 - Severe |  | 1 - Almost Certain | 5 - Severe | Extreme
 |  |  | 1 - Almost Certain~A - Insignificant |  | 1 - Almost Certain | A - Insignificant | Low
 |  |  | 1 - Almost Certain~B - Minor |  | 1 - Almost Certain | B - Minor | Medium
 |  |  | 1 - Almost Certain~C - Moderate |  | 1 - Almost Certain | C - Moderate | High
 |  |  | 1 - Almost Certain~D - Significant |  | 1 - Almost Certain | D - Significant | Extreme
 |  |  | 1 - Almost Certain~E - Severe |  | 1 - Almost Certain | E - Severe | Extreme
 |  |  | A - Almost Certain~Insignificant |  | A - Almost Certain | Insignificant | Low
 |  |  | A - Almost Certain~Minor |  | A - Almost Certain | Minor | Medium
 |  |  | A - Almost Certain~Moderate |  | A - Almost Certain | Moderate | High
 |  |  | A - Almost Certain~Significant |  | A - Almost Certain | Significant | Extreme
 |  |  | A - Almost Certain~Severe |  | A - Almost Certain | Severe | Extreme
 |  |  | A - Almost Certain~1 - Insignificant |  | A - Almost Certain | 1 - Insignificant | Low
 |  |  | A - Almost Certain~2 - Minor |  | A - Almost Certain | 2 - Minor | Medium
 |  |  | A - Almost Certain~3 - Moderate |  | A - Almost Certain | 3 - Moderate | High
 |  |  | A - Almost Certain~4 - Significant |  | A - Almost Certain | 4 - Significant | Extreme
 |  |  | A - Almost Certain~5 - Severe |  | A - Almost Certain | 5 - Severe | Extreme
 |  |  | A - Almost Certain~A - Insignificant |  | A - Almost Certain | A - Insignificant | Low
 |  |  | A - Almost Certain~B - Minor |  | A - Almost Certain | B - Minor | Medium
 |  |  | A - Almost Certain~C - Moderate |  | A - Almost Certain | C - Moderate | High
 |  |  | A - Almost Certain~D - Significant |  | A - Almost Certain | D - Significant | Extreme
 |  |  | A - Almost Certain~E - Severe |  | A - Almost Certain | E - Severe | Extreme
 |  |  | Likely~Insignificant |  | Likely | Insignificant | Low
 |  |  | Likely~Minor |  | Likely | Minor | Medium
 |  |  | Likely~Moderate |  | Likely | Moderate | High
 |  |  | Likely~Significant |  | Likely | Significant | High
 |  |  | Likely~Severe |  | Likely | Severe | Extreme
 |  |  | Likely~1 - Insignificant |  | Likely | 1 - Insignificant | Low
 |  |  | Likely~2 - Minor |  | Likely | 2 - Minor | Medium
 |  |  | Likely~3 - Moderate |  | Likely | 3 - Moderate | High
 |  |  | Likely~4 - Significant |  | Likely | 4 - Significant | High
 |  |  | Likely~5 - Severe |  | Likely | 5 - Severe | Extreme
 |  |  | Likely~A - Insignificant |  | Likely | A - Insignificant | Low
 |  |  | Likely~B - Minor |  | Likely | B - Minor | Medium
 |  |  | Likely~C - Moderate |  | Likely | C - Moderate | High
 |  |  | Likely~D - Significant |  | Likely | D - Significant | High
 |  |  | Likely~E - Severe |  | Likely | E - Severe | Extreme
 |  |  | 2 - Likely~Insignificant |  | 2 - Likely | Insignificant | Low
 |  |  | 2 - Likely~Minor |  | 2 - Likely | Minor | Medium
 |  |  | 2 - Likely~Moderate |  | 2 - Likely | Moderate | High
 |  |  | 2 - Likely~Significant |  | 2 - Likely | Significant | High
 |  |  | 2 - Likely~Severe |  | 2 - Likely | Severe | Extreme
 |  |  | 2 - Likely~1 - Insignificant |  | 2 - Likely | 1 - Insignificant | Low
 |  |  | 2 - Likely~2 - Minor |  | 2 - Likely | 2 - Minor | Medium
 |  |  | 2 - Likely~3 - Moderate |  | 2 - Likely | 3 - Moderate | High
 |  |  | 2 - Likely~4 - Significant |  | 2 - Likely | 4 - Significant | High
 |  |  | 2 - Likely~5 - Severe |  | 2 - Likely | 5 - Severe | Extreme
 |  |  | 2 - Likely~A - Insignificant |  | 2 - Likely | A - Insignificant | Low
 |  |  | 2 - Likely~B - Minor |  | 2 - Likely | B - Minor | Medium
 |  |  | 2 - Likely~C - Moderate |  | 2 - Likely | C - Moderate | High
 |  |  | 2 - Likely~D - Significant |  | 2 - Likely | D - Significant | High
 |  |  | 2 - Likely~E - Severe |  | 2 - Likely | E - Severe | Extreme
 |  |  | B - Likely~Insignificant |  | B - Likely | Insignificant | Low
 |  |  | B - Likely~Minor |  | B - Likely | Minor | Medium
 |  |  | B - Likely~Moderate |  | B - Likely | Moderate | High
 |  |  | B - Likely~Significant |  | B - Likely | Significant | High
 |  |  | B - Likely~Severe |  | B - Likely | Severe | Extreme
 |  |  | B - Likely~1 - Insignificant |  | B - Likely | 1 - Insignificant | Low
 |  |  | B - Likely~2 - Minor |  | B - Likely | 2 - Minor | Medium
 |  |  | B - Likely~3 - Moderate |  | B - Likely | 3 - Moderate | High
 |  |  | B - Likely~4 - Significant |  | B - Likely | 4 - Significant | High
 |  |  | B - Likely~5 - Severe |  | B - Likely | 5 - Severe | Extreme
 |  |  | B - Likely~A - Insignificant |  | B - Likely | A - Insignificant | Low
 |  |  | B - Likely~B - Minor |  | B - Likely | B - Minor | Medium
 |  |  | B - Likely~C - Moderate |  | B - Likely | C - Moderate | High
 |  |  | B - Likely~D - Significant |  | B - Likely | D - Significant | High
 |  |  | B - Likely~E - Severe |  | B - Likely | E - Severe | Extreme
 |  |  | Possible~Insignificant |  | Possible | Insignificant | Low
 |  |  | Possible~Minor |  | Possible | Minor | Medium
 |  |  | Possible~Moderate |  | Possible | Moderate | Medium
 |  |  | Possible~Significant |  | Possible | Significant | High
 |  |  | Possible~Severe |  | Possible | Severe | High
 |  |  | Possible~1 - Insignificant |  | Possible | 1 - Insignificant | Low
 |  |  | Possible~2 - Minor |  | Possible | 2 - Minor | Medium
 |  |  | Possible~3 - Moderate |  | Possible | 3 - Moderate | Medium
 |  |  | Possible~4 - Significant |  | Possible | 4 - Significant | High
 |  |  | Possible~5 - Severe |  | Possible | 5 - Severe | High
 |  |  | Possible~A - Insignificant |  | Possible | A - Insignificant | Low
 |  |  | Possible~B - Minor |  | Possible | B - Minor | Medium
 |  |  | Possible~C - Moderate |  | Possible | C - Moderate | Medium
 |  |  | Possible~D - Significant |  | Possible | D - Significant | High
 |  |  | Possible~E - Severe |  | Possible | E - Severe | High
 |  |  | 3 - Possible~Insignificant |  | 3 - Possible | Insignificant | Low
 |  |  | 3 - Possible~Minor |  | 3 - Possible | Minor | Medium
 |  |  | 3 - Possible~Moderate |  | 3 - Possible | Moderate | Medium
 |  |  | 3 - Possible~Significant |  | 3 - Possible | Significant | High
 |  |  | 3 - Possible~Severe |  | 3 - Possible | Severe | High
 |  |  | 3 - Possible~1 - Insignificant |  | 3 - Possible | 1 - Insignificant | Low
 |  |  | 3 - Possible~2 - Minor |  | 3 - Possible | 2 - Minor | Medium
 |  |  | 3 - Possible~3 - Moderate |  | 3 - Possible | 3 - Moderate | Medium
 |  |  | 3 - Possible~4 - Significant |  | 3 - Possible | 4 - Significant | High
 |  |  | 3 - Possible~5 - Severe |  | 3 - Possible | 5 - Severe | High
 |  |  | 3 - Possible~A - Insignificant |  | 3 - Possible | A - Insignificant | Low
 |  |  | 3 - Possible~B - Minor |  | 3 - Possible | B - Minor | Medium
 |  |  | 3 - Possible~C - Moderate |  | 3 - Possible | C - Moderate | Medium
 |  |  | 3 - Possible~D - Significant |  | 3 - Possible | D - Significant | High
 |  |  | 3 - Possible~E - Severe |  | 3 - Possible | E - Severe | High
 |  |  | C - Possible~Insignificant |  | C - Possible | Insignificant | Low
 |  |  | C - Possible~Minor |  | C - Possible | Minor | Medium
 |  |  | C - Possible~Moderate |  | C - Possible | Moderate | Medium
 |  |  | C - Possible~Significant |  | C - Possible | Significant | High
 |  |  | C - Possible~Severe |  | C - Possible | Severe | High
 |  |  | C - Possible~1 - Insignificant |  | C - Possible | 1 - Insignificant | Low
 |  |  | C - Possible~2 - Minor |  | C - Possible | 2 - Minor | Medium
 |  |  | C - Possible~3 - Moderate |  | C - Possible | 3 - Moderate | Medium
 |  |  | C - Possible~4 - Significant |  | C - Possible | 4 - Significant | High
 |  |  | C - Possible~5 - Severe |  | C - Possible | 5 - Severe | High
 |  |  | C - Possible~A - Insignificant |  | C - Possible | A - Insignificant | Low
 |  |  | C - Possible~B - Minor |  | C - Possible | B - Minor | Medium
 |  |  | C - Possible~C - Moderate |  | C - Possible | C - Moderate | Medium
 |  |  | C - Possible~D - Significant |  | C - Possible | D - Significant | High
 |  |  | C - Possible~E - Severe |  | C - Possible | E - Severe | High
 |  |  | Unlikely~Insignificant |  | Unlikely | Insignificant | Low
 |  |  | Unlikely~Minor |  | Unlikely | Minor | Low
 |  |  | Unlikely~Moderate |  | Unlikely | Moderate | Medium
 |  |  | Unlikely~Significant |  | Unlikely | Significant | Medium
 |  |  | Unlikely~Severe |  | Unlikely | Severe | High
 |  |  | Unlikely~1 - Insignificant |  | Unlikely | 1 - Insignificant | Low
 |  |  | Unlikely~2 - Minor |  | Unlikely | 2 - Minor | Low
 |  |  | Unlikely~3 - Moderate |  | Unlikely | 3 - Moderate | Medium
 |  |  | Unlikely~4 - Significant |  | Unlikely | 4 - Significant | Medium
 |  |  | Unlikely~5 - Severe |  | Unlikely | 5 - Severe | High
 |  |  | Unlikely~A - Insignificant |  | Unlikely | A - Insignificant | Low
 |  |  | Unlikely~B - Minor |  | Unlikely | B - Minor | Low
 |  |  | Unlikely~C - Moderate |  | Unlikely | C - Moderate | Medium
 |  |  | Unlikely~D - Significant |  | Unlikely | D - Significant | Medium
 |  |  | Unlikely~E - Severe |  | Unlikely | E - Severe | High
 |  |  | 4 - Unlikely~Insignificant |  | 4 - Unlikely | Insignificant | Low
 |  |  | 4 - Unlikely~Minor |  | 4 - Unlikely | Minor | Low
 |  |  | 4 - Unlikely~Moderate |  | 4 - Unlikely | Moderate | Medium
 |  |  | 4 - Unlikely~Significant |  | 4 - Unlikely | Significant | Medium
 |  |  | 4 - Unlikely~Severe |  | 4 - Unlikely | Severe | High
 |  |  | 4 - Unlikely~1 - Insignificant |  | 4 - Unlikely | 1 - Insignificant | Low
 |  |  | 4 - Unlikely~2 - Minor |  | 4 - Unlikely | 2 - Minor | Low
 |  |  | 4 - Unlikely~3 - Moderate |  | 4 - Unlikely | 3 - Moderate | Medium
 |  |  | 4 - Unlikely~4 - Significant |  | 4 - Unlikely | 4 - Significant | Medium
 |  |  | 4 - Unlikely~5 - Severe |  | 4 - Unlikely | 5 - Severe | High
 |  |  | 4 - Unlikely~A - Insignificant |  | 4 - Unlikely | A - Insignificant | Low
 |  |  | 4 - Unlikely~B - Minor |  | 4 - Unlikely | B - Minor | Low
 |  |  | 4 - Unlikely~C - Moderate |  | 4 - Unlikely | C - Moderate | Medium
 |  |  | 4 - Unlikely~D - Significant |  | 4 - Unlikely | D - Significant | Medium
 |  |  | 4 - Unlikely~E - Severe |  | 4 - Unlikely | E - Severe | High
 |  |  | D - Unlikely~Insignificant |  | D - Unlikely | Insignificant | Low
 |  |  | D - Unlikely~Minor |  | D - Unlikely | Minor | Low
 |  |  | D - Unlikely~Moderate |  | D - Unlikely | Moderate | Medium
 |  |  | D - Unlikely~Significant |  | D - Unlikely | Significant | Medium
 |  |  | D - Unlikely~Severe |  | D - Unlikely | Severe | High
 |  |  | D - Unlikely~1 - Insignificant |  | D - Unlikely | 1 - Insignificant | Low
 |  |  | D - Unlikely~2 - Minor |  | D - Unlikely | 2 - Minor | Low
 |  |  | D - Unlikely~3 - Moderate |  | D - Unlikely | 3 - Moderate | Medium
 |  |  | D - Unlikely~4 - Significant |  | D - Unlikely | 4 - Significant | Medium
 |  |  | D - Unlikely~5 - Severe |  | D - Unlikely | 5 - Severe | High
 |  |  | D - Unlikely~A - Insignificant |  | D - Unlikely | A - Insignificant | Low
 |  |  | D - Unlikely~B - Minor |  | D - Unlikely | B - Minor | Low
 |  |  | D - Unlikely~C - Moderate |  | D - Unlikely | C - Moderate | Medium
 |  |  | D - Unlikely~D - Significant |  | D - Unlikely | D - Significant | Medium
 |  |  | D - Unlikely~E - Severe |  | D - Unlikely | E - Severe | High
 |  |  | Rare~Insignificant |  | Rare | Insignificant | Low
 |  |  | Rare~Minor |  | Rare | Minor | Low
 |  |  | Rare~Moderate |  | Rare | Moderate | Low
 |  |  | Rare~Significant |  | Rare | Significant | Medium
 |  |  | Rare~Severe |  | Rare | Severe | Medium
 |  |  | Rare~1 - Insignificant |  | Rare | 1 - Insignificant | Low
 |  |  | Rare~2 - Minor |  | Rare | 2 - Minor | Low
 |  |  | Rare~3 - Moderate |  | Rare | 3 - Moderate | Low
 |  |  | Rare~4 - Significant |  | Rare | 4 - Significant | Medium
 |  |  | Rare~5 - Severe |  | Rare | 5 - Severe | Medium
 |  |  | Rare~A - Insignificant |  | Rare | A - Insignificant | Low
 |  |  | Rare~B - Minor |  | Rare | B - Minor | Low
 |  |  | Rare~C - Moderate |  | Rare | C - Moderate | Low
 |  |  | Rare~D - Significant |  | Rare | D - Significant | Medium
 |  |  | Rare~E - Severe |  | Rare | E - Severe | Medium
 |  |  | 5 - Rare~Insignificant |  | 5 - Rare | Insignificant | Low
 |  |  | 5 - Rare~Minor |  | 5 - Rare | Minor | Low
 |  |  | 5 - Rare~Moderate |  | 5 - Rare | Moderate | Low
 |  |  | 5 - Rare~Significant |  | 5 - Rare | Significant | Medium
 |  |  | 5 - Rare~Severe |  | 5 - Rare | Severe | Medium
 |  |  | 5 - Rare~1 - Insignificant |  | 5 - Rare | 1 - Insignificant | Low
 |  |  | 5 - Rare~2 - Minor |  | 5 - Rare | 2 - Minor | Low
 |  |  | 5 - Rare~3 - Moderate |  | 5 - Rare | 3 - Moderate | Low
 |  |  | 5 - Rare~4 - Significant |  | 5 - Rare | 4 - Significant | Medium
 |  |  | 5 - Rare~5 - Severe |  | 5 - Rare | 5 - Severe | Medium
 |  |  | 5 - Rare~A - Insignificant |  | 5 - Rare | A - Insignificant | Low
 |  |  | 5 - Rare~B - Minor |  | 5 - Rare | B - Minor | Low
 |  |  | 5 - Rare~C - Moderate |  | 5 - Rare | C - Moderate | Low
 |  |  | 5 - Rare~D - Significant |  | 5 - Rare | D - Significant | Medium
 |  |  | 5 - Rare~E - Severe |  | 5 - Rare | E - Severe | Medium
 |  |  | E - Rare~Insignificant |  | [NAME] | Insignificant | Low
 |  |  | E - Rare~Minor |  | [NAME] | Minor | Low
 |  |  | E - Rare~Moderate |  | [NAME] | Moderate | Low
 |  |  | E - Rare~Significant |  | [NAME] | Significant | Medium
 |  |  | E - Rare~Severe |  | [NAME] | Severe | Medium
 |  |  | [NAME] |  | [NAME] | 1 - Insignificant | Low
 |  |  | E - Rare~2 - Minor |  | [NAME] | 2 - Minor | Low
 |  |  | E - Rare~3 - Moderate |  | [NAME] | 3 - Moderate | Low
 |  |  | E - Rare~4 - Significant |  | [NAME] | 4 - Significant | Medium
 |  |  | E - Rare~5 - Severe |  | [NAME] | 5 - Severe | Medium
 |  |  | E - Rare~A - Insignificant |  | [NAME] | A - Insignificant | Low
 |  |  | E - Rare~B - Minor |  | [NAME] | B - Minor | Low
 |  |  | E - Rare~C - Moderate |  | [NAME] | C - Moderate | Low
 |  |  | E - Rare~D - Significant |  | [NAME] | D - Significant | Medium
 |  |  | E - Rare~E - Severe |  | [NAME] | E - Severe | Medium