Spreadsheet: 743823d1628758021-risk-matrix-visualization-function-riskmatrixv2
Sheet: data (2)

1 | 8 | 15 |  | Task: Use the blank risk matrix on bottom of the next sheet to visualize which kind of risk is in each cell by displaying the Nr.(column A) in the coloured cells. I tried to use commands such as sumproduct or countif but these only work with numerical values, I want to print all cells that fulfill a characteristic in the right cell. As there are over 80 values, I'll probaly kust hide all yellow and orange one and just display the few (important) red ones. Thanks for the help!
2 | 9 | 16
3 | 10 | 17
4 | 11 | 18
5 | 12 | 19
6 | 13 | 20
7 | 14 | 21
Nr. |  |  | Risk-Description | Other Stuff |  |  |  |  |  |  |  |  |  | Probability of occurrence [1 - 5] | Impact [1 - 5] | Risk number
1 |  |  | Strategic Risk
 |  |  | A |  |  |  |  |  |  |  |  |  |  | 1 | 4
 |  |  | B |  |  |  |  |  |  |  |  |  |  | 2 | 2
 |  |  | C |  |  |  |  |  |  |  |  |  |  | 3 | 4
 |  |  | D |  |  |  |  |  |  |  |  |  |  | 4 | 1
2 |  |  | Regulatory Risk
 |  |  | AA |  |  |  |  |  |  |  |  |  |  | 2 | 1
 |  |  | BB |  |  |  |  |  |  |  |  |  |  | 2 | 3
 |  |  | CC |  |  |  |  |  |  |  |  |  |  | 3 | 2
 |  |  | DD |  |  |  |  |  |  |  |  |  |  | 1 | 1
2.4 |  |  | DD |  |  |  |  |  |  |  |  |  |  | 2 | 1
2.4 |  |  | DD |  |  |  |  |  |  |  |  |  |  | 4 | 4
3 |  |  | Financial Risk
 |  |  | AAA |  |  |  |  |  |  |  |  |  |  | 4 | 4
 |  |  | AAA |  |  |  |  |  |  |  |  |  |  | 5 | 5
 |  |  | AAA |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  | BBB |  |  |  |  |  |  |  |  |  |  | 3 | 2
 |  |  | CCC |  |  |  |  |  |  |  |  |  |  | 4 | 4
 |  |  | DDD |  |  |  |  |  |  |  |  |  |  | 2 | 1
 |  |  | EEE |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  | EEE |  |  |  |  |  |  |  |  |  |  | 5 | 2
 |  |  | EEE |  |  |  |  |  |  |  |  |  |  | 3 | 3
 |  |  | FFF |  |  |  |  |  |  |  |  |  |  | 2 | 2
 |  |  | FFF |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  | FFF |  |  |  |  |  |  |  |  |  |  | 2 | 2
 |  |  | GGG |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  | GGG |  |  |  |  |  |  |  |  |  |  | 2 | 3
 |  |  | HHH |  |  |  |  |  |  |  |  |  |  | 3 | 2
 |  |  | III |  |  |  |  |  |  |  |  |  |  | 4 | 1
 |  |  | III |  |  |  |  |  |  |  |  |  |  | 1 | 2
 |  |  | JJJ |  |  |  |  |  |  |  |  |  |  | 2 | 1
 |  |  | JJJ |  |  |  |  |  |  |  |  |  |  | 5 | 3
 |  |  | KKK |  |  |  |  |  |  |  |  |  |  | 5 | 1
 |  |  | LLL |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  | MMM |  |  |  |  |  |  |  |  |  |  | 2 | 3
 |  |  | NNN |  |  |  |  |  |  |  |  |  |  | 3 | 1
 |  |  | OOO |  |  |  |  |  |  |  |  |  |  | 1 | 2
 |  |  | PPP |  |  |  |  |  |  |  |  |  |  | 2 | 2
 |  |  | QQQ |  |  |  |  |  |  |  |  |  |  | 3 | 3
 |  |  | RRR |  |  |  |  |  |  |  |  |  |  | 1 | 4
4 |  |  | Operating Risk
 |  |  | a |  |  |  |  |  |  |  |  |  |  | 1 | 4
 |  |  | a |  |  |  |  |  |  |  |  |  |  | 2 | 2
 |  |  | a |  |  |  |  |  |  |  |  |  |  | 3 | 4
 |  |  | a |  |  |  |  |  |  |  |  |  |  | 1 | 5
 |  |  | a |  |  |  |  |  |  |  |  |  |  | 1 | 5
 |  |  | a |  |  |  |  |  |  |  |  |  |  | 2 | 1
 |  |  | b |  |  |  |  |  |  |  |  |  |  | 3 | 5
 |  |  | b |  |  |  |  |  |  |  |  |  |  | 3 | 2
 |  |  | b |  |  |  |  |  |  |  |  |  |  | 1 | 3
 |  |  | b |  |  |  |  |  |  |  |  |  |  | 2 | 1
 |  |  | b |  |  |  |  |  |  |  |  |  |  | 4 | 3
5 |  |  | Risk
 |  |  | aa |  |  |  |  |  |  |  |  |  |  | 2 | 1
 |  |  | aa |  |  |  |  |  |  |  |  |  |  | 2 | 3
 |  |  | aa |  |  |  |  |  |  |  |  |  |  | 3 | 3
 |  |  | bb |  |  |  |  |  |  |  |  |  |  | 2 | 2
 |  |  | cc |  |  |  |  |  |  |  |  |  |  | 2 | 1
 |  |  | cc |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  | cc |  |  |  |  |  |  |  |  |  |  | 2 | 3
 |  |  | cc |  |  |  |  |  |  |  |  |  |  | 3 | 5
 |  |  | dd |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  | dd |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  | dd |  |  |  |  |  |  |  |  |  |  | 1 | 2
 |  |  | dd |  |  |  |  |  |  |  |  |  |  | 1 | 3
 |  |  | dd |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  | dd |  |  |  |  |  |  |  |  |  |  | 2 | 1
 |  |  | dd |  |  |  |  |  |  |  |  |  |  | 4 | 3
 |  |  | ee |  |  |  |  |  |  |  |  |  |  | 1 | 4
 |  |  | ff |  |  |  |  |  |  |  |  |  |  | 1 | 5
 |  |  | ff |  |  |  |  |  |  |  |  |  |  | 2 | 1
 |  |  | ff |  |  |  |  |  |  |  |  |  |  | 1 | 5
 |  |  | gg |  |  |  |  |  |  |  |  |  |  | 2 | 2
 |  |  | hh |  |  |  |  |  |  |  |  |  |  | 4 | 3
6 |  |  | Operating Risk
 |  |  | a |  |  |  |  |  |  |  |  |  |  | 1 | 4
 |  |  | b |  |  |  |  |  |  |  |  |  |  | 2 | 2
 |  |  | c |  |  |  |  |  |  |  |  |  |  | 1 | 4
 |  |  | d |  |  |  |  |  |  |  |  |  |  | 5 | 4
7 |  |  | Risk
2.1 |  |  | aaaa |  |  |  |  |  |  |  |  |  |  | 2 | 1
2.2 |  |  | bbbb |  |  |  |  |  |  |  |  |  |  | 2 | 3
2.3 |  |  | cccc |  |  |  |  |  |  |  |  |  |  | 2 | 3
2.4 |  |  | dddd |  |  |  |  |  |  |  |  |  |  | 3 | 2
2.5 |  |  | eeee |  |  |  |  |  |  |  |  |  |  | 2 | 4
2.6 |  |  | ffff |  |  |  |  |  |  |  |  |  |  | 1 | 5