三條件符合 取值 (10980)

I2{=INDEX(D:D,RIGHT(MAX(IF((A$2:A$16=F2)*(B$2:B$16=G2)*(C$2:C$16<=H2),C$2:C$16)/1%+ROW($2:$16)),2))

另解=INDEX(D:D,MATCH(1,FREQUENCY(-9^9,-($A$2:$A$28=F2)*($B$2:$B$28=G2)*($C$2:$C$28<=H2)*$C$2:$C$28),)+1)