取代數據 依表列 (13452)

B2=SUBSTITUTE(A2,LOOKUP(1,0/FIND("-"&E$2:E$9&"-",A2),E$2:E$9),LOOKUP(1,0/FIND("-"&E$2:E$9&"-",A2),F$2:F$9))

另解=LOOKUP(1,0/(SUBSTITUTE(A2,"-"&E$2:E$9&"-","-"&F$2:F$9&"-")<>A2),SUBSTITUTE(A2,"-"&E$2:E$9&"-","-"&F$2:F$9&"-"))