類似關鍵字 取對應值 (11163)

C2{=INDEX(G:G,RIGHT(MAX(IF(1-ISERR(FIND(F$2:F11,A2)),LEN(F$2:F11)/1%+ROW($2:11))),2))

另解=LOOKUP(1,0/FREQUENCY(-99,LEN(SUBSTITUTE(A2,F$2:F$11,))-LEN(A2)),G$2:G$11)