相同物料 取最后日期基准价 (11024)

E2=IF(COUNTIFS(B:B,B2,C:C,">"&C2)=0,D2,"")

H2=LOOKUP(1,0/(B$2:B$16=G2)/(COUNTIFS(B:B,B$2:B$16,C:C,">"&C$2:C$16)=0),D$2:D$16)