I am trying to auto populate the risk level of an item based on the selection from two fields and where they intersect in a matrix
Column A = Impact; dropdown selection
Column B = Probability; drop selection
Column C = Risk Level; calculated based on the selection in the above two fields and where they intersect in the matrix
<tbody>
</tbody>
<tbody>
</tbody>
Column A = Impact; dropdown selection
Column B = Probability; drop selection
Column C = Risk Level; calculated based on the selection in the above two fields and where they intersect in the matrix
A | B | C | |
1 | Impact | Probability | Risk Level |
2 | Medium | Likely | Medium |
<tbody>
</tbody>
<colgroup><col width="87" span="6" style="width: 65pt;"></colgroup><tbody> </tbody> |
<tbody>
</tbody>