The MATCH() functions rank the data from one to three as follows:

Minor or Unlikely = 1
Moderate or Likely = 2
Significant or Imminent = 3

The CHOOSE() function selects the correct result. Based upon your data, when
adding those ranks together a total of either 5 or 6 was High, 4 was Medium and
1 through 3 was Low.


tim m wrote:
Thanks for all the responses.

I used Glenns formula and it worked nicely. (Now I have to reverse engineer
it to learn why it worked.) I think I will use this formula rather than the
other methods because I will be using this on ad hoc type of reports rather
than a more permanent report. thus it will be easier to not create a grid
each time I have to make use of it.

Once again, thanks alot Gents!

"Glenn" wrote:

One possible way:

=CHOOSE(MATCH(A1,{"Minor","Moderate","Significant" },0)
+MATCH(B1,{"Unlikely","Likely","Imminent"},0)
,"Low","Low","Low","Medium","High","High")


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.