Hi,
This might be simplistic - apologies!
I have a Risk Factor reference table in 1 sheet:
↓Likelihood Consequence→
Major Moderate Minor
Likely High High Medium
Possible High Medium Low
Unlikely Medium Low Low
In another sheet I have the columns
Description Consequence Likelihood Risk Factor
I want to put a formula in the Risk factor field that will look at the value typed into the Likelihood (Likely, Possible or Unlikely) and the Consequence column (Major, Moderate or Minor) - look up the 'reference table' and return with either the high, medium or low value as appropriate.
I know I can do a long nested IF statement but is there a better way?
Thank you for your time!
Katie
This might be simplistic - apologies!
I have a Risk Factor reference table in 1 sheet:
↓Likelihood Consequence→
Major Moderate Minor
Likely High High Medium
Possible High Medium Low
Unlikely Medium Low Low
In another sheet I have the columns
Description Consequence Likelihood Risk Factor
I want to put a formula in the Risk factor field that will look at the value typed into the Likelihood (Likely, Possible or Unlikely) and the Consequence column (Major, Moderate or Minor) - look up the 'reference table' and return with either the high, medium or low value as appropriate.
I know I can do a long nested IF statement but is there a better way?
Thank you for your time!
Katie
Last edited: