Hi

There may be better ways..

=IFERROR(LOOKUP(3,CHOOSE({1,2,3,4},IF(AND(ISNUMBER (SEARCH("j",A2)),OR(NOT(ISNUMBER(SEARCH("k",A2))), NOT(ISNUMBER(SEARCH("l",A2))))),1,""),IFERROR(IF(A ND(SUM(SEARCH({"j","k"},A2)*{1,-1})<0,ISNUMBER(SEARCH("l",MID(A2,SEARCH("k",A2),25 5)))),1,""),""),IFERROR(IF(AND(SUM(SEARCH({"j","l" },A2)*{1,-1})<0,NOT(ISNUMBER(SEARCH("k",A2)))),1,""),""),IFE RROR(IF(SUM(SEARCH({"j","k"},A2)*{1,-1})<0,1,2),""))),"")