title: Excel: How to apply a formula to multiple cells while changing only one parameter?
body: <p>I'm trying to apply an INDEX/MATCH formula to multiple cells, and the only parameter I want to change in between cells is the "col_number". It this possible?</p>
  
  <p>Example:
  =INDEX(Sheet2!$A1:$APH344,MATCH(Sheet1!$A2,Sheet2!$A:$A,0),2)</p>
  
  <p>In the next cell over, I would like to keep everything equal, but change that last "2" to "3":
  =INDEX(Sheet2!$A1:$APH344,MATCH(Sheet1!$A2,Sheet2!$A:$A,0),3)</p>
  
  <p>Then:
  =INDEX(Sheet2!$A1:$APH344,MATCH(Sheet1!$A2,Sheet2!$A:$A,0),4)</p>
  
  <p>And so on..</p>
  
  <p>Is there any way to apply this pattern to many cells (i.e. 100s of cells) quickly? Thanks!</p>