最近一个日期的单价 (10088)

G2=LOOKUP(1,0/(MAX((A$2:A$17=F2)*B$2:B$17)=B$2:B$17)/(A$2:A$17=F2),C$2:C$17)

另解 {=MOD(MAX((A$2:A$17=F2)*B$2:B$17/1%+C$2:C$17),100)

另解 {=LOOKUP(,0/FREQUENCY(-9^9,-IF($A$2:$A$17=F2,$B$2:$B$17)),$C$2:$C$17)