模糊匹配 (12146)

I2{=IF(H2="","",INDEX(B:B,RIGHT(MAX(MMULT(1-ISERR(0/(FIND(MID(H2,COLUMN(A:Z),4),A$2:A$9)-1)),ROW(1:26)^0)/1%+ROW($2:$9)),2)))

另解{=IF(H2="","",INDEX(B:B,MODE(IF(ISNUMBER(FIND(MID(H2,COLUMN(A:AZ),1),A$2:A$9)),ROW($A$2:$A$9)))))