两邊數據做比對 (14846)

C1=IFERROR(B1-VLOOKUP("*"&MID(A1,FIND(".",A1)+1,9),E:F,2,),"無")

另解=IFERROR(B1-VLOOKUP(TEXT(-1%,SUBSTITUTE(A1,".",";!*")),E:F,2,),"無")