title: Add a fixed amount to formula range
body: <p>I am working with a long INDEX/MATCH with 30 tables of data. I have to repeat the formula 30 times.</p>
  
  <p>First range is F10:F24. Second range is F29:F43 and so on therefore ranges 2~30 are 19 rows down the previous one. Dragging the cell to the right is not going to work in this case, so is there any other way to avoid editing 30 long formulas?</p>
  
  <p>Edit:</p>
  
  <p>Here are two partial samples for first and second column:</p>
  
  <p>=INDEX(Fixtures!$F$10:$F$24,MATCH(T!$C$4,Fixtures!$E$10:$E$24,0),1)
  =INDEX(Fixtures!$F$29:$F$43,MATCH(T!$C$4,Fixtures!$E$29:$E$43,0),1)</p>