二條件最大值 (11062)

G2:H4{=INDEX(B:B,RIGHT(MAX(($A$2:$A$17=$E2)*($C$2:$C$17<$F2)*ROUND($C$2:$C$17,6)*10^9+ROW($2:$17)),2))