title: Excel: Get nth occurrence with multiple criteria (INDEX/MATCH)
body: <p>I would like a formula to find the second occurrence of column A with "c" and "n" in columns B and C respectively.</p>
  
  <pre><code>A   B   C
  1   a   m
  2   b   n
  3   c   m
  4   a   p
  5   b   m
  6   c   n
  7   a   m
  8   b   p
  9   c   n
  </code></pre>
  
  <p>The solution is: 9.</p>
  
  <p>So far, I know how to get the nth occurence with one criteria:
  <code>=INDEX(A2:A10;SMALL(IF(C2:C10="n";ROW(C2:C10)-ROW(INDEX(C2:C10;1;1))+1);2))</code></p>