模糊查找 (13150)

H2{=INDIRECT(TEXT(MAX((B$1:E$1=F2)*ISNUMBER(FIND(G2,B$2:E$5))*ROW($2:$5)/1%+COLUMN(B:E)),"!R0C00"),)

另解{=LOOKUP(9,-FIND(G2,HLOOKUP(F2,B:E,ROW($1:$99),)),HLOOKUP(F2,B:E,ROW($1:$99),))

另解{=VLOOKUP("*"&G2&"*",OFFSET($A$1,,MATCH(F2,$1:$1,)-1,99)&"",1,)