類似代號 找對應值 (13049)

B2{=LOOKUP(1,0/(LEFT(A2,MAX((LEFT(A2,LEN(E$2:E$6))-E$2:E$6=0)*LEN(E$2:E$6)))-E$2:E$6=0),F$2:F$6)

I2=LOOKUP(1,0/(FIND(K$2:K$6,H2)=1),L$2:L$6)