title: Changing the row reference when dragging down index match formula in excel
body: <p>I am trying to reference the formula below to pick up the next row when I drag it down my workbook so that the 1 becomes 2, 3, 4 etc. What is the most efficient way of doing this?</p>
  
  <pre><code>=(INDEX(Data!$A:$M,MATCH(1,(Data!$E:$E=$B$1)*(Data!$F:$F=$B$2),0)*1,3))
  </code></pre>
  
  <p>Thanks,</p>
  
  <p>Richard </p>