寫一寫也覺得挺噁心的。=INDEraw!D$2$1600,MATCH(MIN(IF(raw!F2:F1600=B3,IF(raw!I2:I1600="ok",IF(raw!U2:U1600>0,raw!C2:C1600)))),raw!C2:C1600,0),0)

不如用python win32com連excel好了