title: Finding minimum value in index(match) array [EXCEL]
body: <p>This is my simple table</p>
  
  <pre><code>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
  </code></pre>
  
  <p>index match array formula:</p>
  
  <pre><code>=INDEX(A2:C9,MATCH(1,(H4=$A:$A)*(I4=$B:$B),0),3)
  </code></pre>
  
  <p>Basically A and B are my lookup criteria while C is the value I want to get. I want C to be the minimum value among the matched C value. </p>
  
  <p>Ex. 
  If I have tasmania and hobart as my criteria, I would want to get 17 because it is the minimum value and not 21.</p>
  
  <p>I tried nesting <code>MIN</code> inside the index match array <code>(H4=$A:$A)*(I4=$B:$B)*(MIN($C:$C))</code> but it only results in errors</p>