升中文一級 (9552)

C2=LOOKUP(1,FIND(B2,SUBSTITUTE(TEXT(ROW($1:$98),"[dbnum1]")&"级","一十","十")),SUBSTITUTE(TEXT(ROW($2:$99),"[dbnum1]")&"级","一十","十"))

另解{=VLOOKUP(B2,SUBSTITUTE(TEXT(ROW($1:$98)-{1,0},"[dbnum1]")&"级","一十","十"),2,)