判斷對應編號前四碼 出現任一 (11924)

D2=IF(SUMPRODUCT(MMULT(N(LEFT(C$2:C$15,4)={"0101","0102"}),{1;1})*(B$2:B$15=B2)),"正確","錯誤")