This post demonstrates how to find minimum and maximum value using two conditions. In this case they are date conditions but they can be whatever you like, displayed in cell C3 and E3.

The maximum value in that date range is calculated in cell C6, The minimum value in cell C7. There is also a formula that finds these values and return their corresponding date, in cell E6 and E7.

Formula in cell C6:

=MAXIFS($C$10:$C$39,$B$10:$B$39,"<="&$E$3,$B$10:$B$39,">="&$C$3)

Formula in cell C7:

=MINIFS($C$10:$C$39,$B$10:$B$39,"<="&$E$3,$B$10:$B$39,">="&$C$3)

Formula in cell E6:

=INDEX($B$10:$B$39,MATCH(C6,$C$10:$C$39,0))

Formula in cell E7:

=INDEX($B$10:$B$39,MATCH(C7,$C$10:$C$39,0))

Download excel *.xlsx file

Lookup min max values in a date range.xlsx