Greetings:

In Column A I will have text data that will be "Significant", "Moderate" or
"Minor"
In Column B I will have text data that will be "Imminent", "Likely",
"Unlikely"

In column C depending on the data in A & B I want to display a result that
which will be "High", "Medium" or "Low"

Significant, Imminent = High
Significant, Likely = High
Moderate, Imminent = High
Significant, Unlikely = Medium
Moderate, Likely = Medium
Minor, Imminent = Medium
Moderate, Unlikely = Low
Minor, Likely = Low
Minor, Unlikely = Low

What function would be the best to use here. One could make a ponderous IF
statement but I'm assuming there is a better way and a better function to use.