Finding the minimum value in an index (match) array [EXCEL]

Question

This is my simple table.

A                           B               C
tasmania                   hobart            21
queensland                 brisbane          22
new south wales            sydney            23
northern territory         darwin            24
south australia            adelaide          25
western australia          perth             26
tasmania                   hobart            17
queensland                 brisbane          18
new south wales            sydney            19
northern territory        darwin             11
south australia           adelaide           12
western australia         perth              13

column matching formula:

=INDEX(A2:C9,MATCH(1,(H4=$A:$A)*(I4=$B:$B),0),3)

Mostly A and B are my search criteria, and C is the value I want to get. I want C to be the minimum value among the consistent value of C.

Ex. If I have tasmania and hobart as my criteria, I would like to get 17 because this is the minimum value, not 21.

I tried to nest MINinside an array of matches with the index (H4=$A:$A)*(I4=$B:$B)*(MIN($C:$C)), but this only leads to errors

Answer 1

MIN(IF..., a INDEX. SUMIF COUNTIF Excel, SUM(IF... COUNT(IF....

MINIFS, :

{=MIN(IF($A$1:$A$1000=H4,IF($B$1:$B$1000=I4,$C$1:$C$1000,NA())))}

. [Ctrl] + [Shift] + [Enter] . .

Answer 2

AGGREGATE ,

=AGGREGATE(15, 6, C2:INDEX(C:C, MATCH(1E+99,C:C ))/((A2:INDEX(A:A, MATCH(1E+99,C:C ))=F2)*(B2:INDEX(B:B, MATCH(1E+99,C:C ))=G2)), 1)

, ,

=MIN(INDEX(C2:C13+((H4<>A2:A13)+(I4<>B2:B13))*1E+99, , ))