括弧內字符串 匹配 (12590)

B2=IFERROR(LOOKUP(1,0/FIND(LEFT(C$2:C$5,FIND("/",C$2:C$5)-1),A2),C$2:C$5),"")



留言