Enter

=LOOKUP(MAX(LOOKUP(A2:C2,{"Crit","High","Low","Mod "},{4,3,1,2})),{1,2,3,4},{"Low","Mod","High","Crit "})

in cell D2 as an array formula confirmed with Ctrl+Shift+Enter and drag it
down!

Regards,
Stefi

€žRod€� ezt Ã*rta:

Similar to the MAX function where it compares several cells of number and
returns the highest value, it is possible to compare several cells of text
and return the highest value based on a customized list.
For example the customized list could be: Critical, High, Moderate and lower
Col A Col B Col C Col with formula to return highest value of Col A, B, C
Crit High Low Crit
Low Mod Low Mod
Low Mod High High

Thanks,
Rod