Spreadsheet: 861808d1709643708-risk-matrix-using-ranges-of-labels-risk-matrix-post
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")
 | Almost Certain | Insignificant |  |  |  | Insignificant | Low |  | Likelihood = | 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 | Minor |  |  |  | Minor | Medium
 | A - Almost Certain | Moderate |  |  |  | Moderate | High |  | Consequence = | 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
 | Likely | Significant |  |  |  | Significant | Extreme
 | 2 - Likely | Severe |  |  |  | Severe | Extreme
 | B - Likely | 1 - Insignificant |  |  |  | 1 - Insignificant | Low |  | Cells E3:E5 contain: | Insignificant | 1 - Insignificant | A - Insignificant
 | Possible | 2 - Minor |  |  |  | 2 - Minor | Medium |  | Cells F3:F5 contain: | Minor | 2 - Minor | B - Minor
 | 3 - Possible | 3 - Moderate |  |  |  | 3 - Moderate | High |  | Cells G3:G5 contain: | Moderate | 3 - Moderate | C - Moderate
 | C - Possible | 4 - Significant |  |  |  | 4 - Significant | Extreme |  | Cells H3:H5 contain: | Significant | 4 - Significant | D - Significant
 | Unlikely | 5 - Severe |  |  |  | 5 - Severe | Extreme |  | Cells I3:I5 contain: | Severe | 5 - Severe | E - Severe
 | 4 - Unlikely | A - Insignificant |  |  |  | A - Insignificant | Low
 | D - Unlikely | B - Minor |  |  |  | B - Minor | Medium |  | Cells B6:D6 contain: | Almost Certain | 1 - Almost Certain | A - Almost Certain
 | Rare | C - Moderate |  |  |  | C - Moderate | High |  | Cells B7:D7 contain: | Likely | 2 - Likely | B - Likely
 | 5 - Rare | D - Significant |  |  |  | D - Significant | Extreme |  | Cells B8:D8 contain: | Possible | 3 - Possible | C - Possible
 | [NAME] | E - Severe |  |  |  | E - Severe | Extreme |  | Cells B9:D9 contain: | Unlikely | 4 - Unlikely | D - Unlikely
 |  |  |  |  |  | Insignificant | Low |  | Cells B10:D10 contain: | Rare | 5 - Rare | [NAME]
 |  |  |  |  |  | Minor | Medium
 |  |  |  |  |  | Moderate | High |  | Matrix in cells: | E6:I10
 |  |  |  |  |  | Significant | Extreme
 |  |  |  |  |  | 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 - Insignificant | Low |  |  | There will 15 copies of 'Almost Certain' followed by another 15 copies of '1 - Almost Certain'
 |  |  |  |  |  | 2 - Minor | Medium
 |  |  |  |  |  | 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
 |  |  |  |  |  | 4 - Significant | Extreme |  |  | These values will be pasted adjacent each of the 15 groups
 |  |  |  |  |  | 5 - Severe | Extreme
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Medium
 |  |  |  |  |  | C - Moderate | High
 |  |  |  |  |  | D - Significant | Extreme
 |  |  |  |  |  | E - Severe | Extreme
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Medium
 |  |  |  |  |  | Moderate | High
 |  |  |  |  |  | Significant | Extreme
 |  |  |  |  |  | Severe | Extreme
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Medium
 |  |  |  |  |  | 3 - Moderate | High
 |  |  |  |  |  | 4 - Significant | Extreme
 |  |  |  |  |  | 5 - Severe | Extreme
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Medium
 |  |  |  |  |  | C - Moderate | High
 |  |  |  |  |  | D - Significant | Extreme
 |  |  |  |  |  | E - Severe | Extreme
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Medium
 |  |  |  |  |  | Moderate | High
 |  |  |  |  |  | Significant | High
 |  |  |  |  |  | Severe | Extreme
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Medium
 |  |  |  |  |  | 3 - Moderate | High
 |  |  |  |  |  | 4 - Significant | High
 |  |  |  |  |  | 5 - Severe | Extreme
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Medium
 |  |  |  |  |  | C - Moderate | High
 |  |  |  |  |  | D - Significant | High
 |  |  |  |  |  | E - Severe | Extreme
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Medium
 |  |  |  |  |  | Moderate | High
 |  |  |  |  |  | Significant | High
 |  |  |  |  |  | Severe | Extreme
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Medium
 |  |  |  |  |  | 3 - Moderate | High
 |  |  |  |  |  | 4 - Significant | High
 |  |  |  |  |  | 5 - Severe | Extreme
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Medium
 |  |  |  |  |  | C - Moderate | High
 |  |  |  |  |  | D - Significant | High
 |  |  |  |  |  | E - Severe | Extreme
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Medium
 |  |  |  |  |  | Moderate | High
 |  |  |  |  |  | Significant | High
 |  |  |  |  |  | Severe | Extreme
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Medium
 |  |  |  |  |  | 3 - Moderate | High
 |  |  |  |  |  | 4 - Significant | High
 |  |  |  |  |  | 5 - Severe | Extreme
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Medium
 |  |  |  |  |  | C - Moderate | High
 |  |  |  |  |  | D - Significant | High
 |  |  |  |  |  | E - Severe | Extreme
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Medium
 |  |  |  |  |  | Moderate | Medium
 |  |  |  |  |  | Significant | High
 |  |  |  |  |  | Severe | High
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Medium
 |  |  |  |  |  | 3 - Moderate | Medium
 |  |  |  |  |  | 4 - Significant | High
 |  |  |  |  |  | 5 - Severe | High
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Medium
 |  |  |  |  |  | C - Moderate | Medium
 |  |  |  |  |  | D - Significant | High
 |  |  |  |  |  | E - Severe | High
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Medium
 |  |  |  |  |  | Moderate | Medium
 |  |  |  |  |  | Significant | High
 |  |  |  |  |  | Severe | High
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Medium
 |  |  |  |  |  | 3 - Moderate | Medium
 |  |  |  |  |  | 4 - Significant | High
 |  |  |  |  |  | 5 - Severe | High
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Medium
 |  |  |  |  |  | C - Moderate | Medium
 |  |  |  |  |  | D - Significant | High
 |  |  |  |  |  | E - Severe | High
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Medium
 |  |  |  |  |  | Moderate | Medium
 |  |  |  |  |  | Significant | High
 |  |  |  |  |  | Severe | High
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Medium
 |  |  |  |  |  | 3 - Moderate | Medium
 |  |  |  |  |  | 4 - Significant | High
 |  |  |  |  |  | 5 - Severe | High
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Medium
 |  |  |  |  |  | C - Moderate | Medium
 |  |  |  |  |  | D - Significant | High
 |  |  |  |  |  | E - Severe | High
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Low
 |  |  |  |  |  | Moderate | Medium
 |  |  |  |  |  | Significant | Medium
 |  |  |  |  |  | Severe | High
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Low
 |  |  |  |  |  | 3 - Moderate | Medium
 |  |  |  |  |  | 4 - Significant | Medium
 |  |  |  |  |  | 5 - Severe | High
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Low
 |  |  |  |  |  | C - Moderate | Medium
 |  |  |  |  |  | D - Significant | Medium
 |  |  |  |  |  | E - Severe | High
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Low
 |  |  |  |  |  | Moderate | Medium
 |  |  |  |  |  | Significant | Medium
 |  |  |  |  |  | Severe | High
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Low
 |  |  |  |  |  | 3 - Moderate | Medium
 |  |  |  |  |  | 4 - Significant | Medium
 |  |  |  |  |  | 5 - Severe | High
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Low
 |  |  |  |  |  | C - Moderate | Medium
 |  |  |  |  |  | D - Significant | Medium
 |  |  |  |  |  | E - Severe | High
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Low
 |  |  |  |  |  | Moderate | Medium
 |  |  |  |  |  | Significant | Medium
 |  |  |  |  |  | Severe | High
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Low
 |  |  |  |  |  | 3 - Moderate | Medium
 |  |  |  |  |  | 4 - Significant | Medium
 |  |  |  |  |  | 5 - Severe | High
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Low
 |  |  |  |  |  | C - Moderate | Medium
 |  |  |  |  |  | D - Significant | Medium
 |  |  |  |  |  | E - Severe | High
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Low
 |  |  |  |  |  | Moderate | Low
 |  |  |  |  |  | Significant | Medium
 |  |  |  |  |  | Severe | Medium
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Low
 |  |  |  |  |  | 3 - Moderate | Low
 |  |  |  |  |  | 4 - Significant | Medium
 |  |  |  |  |  | 5 - Severe | Medium
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Low
 |  |  |  |  |  | C - Moderate | Low
 |  |  |  |  |  | D - Significant | Medium
 |  |  |  |  |  | E - Severe | Medium
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Low
 |  |  |  |  |  | Moderate | Low
 |  |  |  |  |  | Significant | Medium
 |  |  |  |  |  | Severe | Medium
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Low
 |  |  |  |  |  | 3 - Moderate | Low
 |  |  |  |  |  | 4 - Significant | Medium
 |  |  |  |  |  | 5 - Severe | Medium
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Low
 |  |  |  |  |  | C - Moderate | Low
 |  |  |  |  |  | D - Significant | Medium
 |  |  |  |  |  | E - Severe | Medium
 |  |  |  |  |  | Insignificant | Low
 |  |  |  |  |  | Minor | Low
 |  |  |  |  |  | Moderate | Low
 |  |  |  |  |  | Significant | Medium
 |  |  |  |  |  | Severe | Medium
 |  |  |  |  |  | 1 - Insignificant | Low
 |  |  |  |  |  | 2 - Minor | Low
 |  |  |  |  |  | 3 - Moderate | Low
 |  |  |  |  |  | 4 - Significant | Medium
 |  |  |  |  |  | 5 - Severe | Medium
 |  |  |  |  |  | A - Insignificant | Low
 |  |  |  |  |  | B - Minor | Low
 |  |  |  |  |  | C - Moderate | Low
 |  |  |  |  |  | D - Significant | Medium
 |  |  |  |  |  | E - Severe | Medium