Formula to Check Values no matter how many, if value exists then return that value.

[Bullzye11]

Hi There,

I have a Risk Matrix which has the Values of "Almost Certain","Likely","Possible","Unlikely" and lastly "Rare".

I want to check in a range those values in hierarchy and if e.g. "Possible" is there the most then return "Possible".

Alternatively, in another cell I want to check the same range those values in hierarchy and if e.g. "Possible" is the highest value then return "Possible".

So far i came up with the following - =IF($J$62:$J$67="Almost Certain","Almost Certain", IF(MATCH("Likely",$J$62:$J$67,0),"Likely", IF(MATCH("Possible",$J$62:$J$67,0),"Possible", IF(MATCH("Unlikely",$J$62:$J$67,0),"Unlikely", IF(MATCH("Likely",$J$62:$J$67,0),"Likely", IF(MATCH("Rare",$J$62:$J$67,0), "Rare","ERROR")))))))

Problem is I get an error every time?? Any ideas would be awesome for both??

Thanks!