Hi,

Risk assesments, great fum. I'd build a table like the one below out of the
way which I've put in J1 - M4

Then this formula in B1 and drag down

=INDEX($J$1:$M$4,MATCH(A1,$J$1:$M$1,0),MATCH(B1,$J $1:$J$4,0))

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


Mike

"tim m" wrote:

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.