title: Increase row number by fixed amount in Excel
body: <p>I am struggling to find a way to increase row number in external excel source file.</p>
  
  <p>Let's say I have <code>M4</code>, in which I want to have the value from <code>naujas.xlsx</code> Worksheet <code>C3005</code> cell.</p>
  
  <p><code>M5</code> should show value from <code>C3029</code>. So the row count should increase by <code>24</code>.</p>
  
  <p>I have tried using <code>INDIRECT</code>, <code>OFFSET</code> and <code>INDEX</code>.</p>
  
  <p>It would be best if this would work with INDEX as it allows the external file to be not loaded.
  I want to be able to drag the formula down.</p>
  
  <pre><code>=OFFSET("[naujas.xlsx]Worksheet!$C$3005",ROW()+24,0,1,1)
  =INDEX('C:\Users\user\Desktop[naujas.xlsx]Worksheet'!$C:$C,(ROW(1:1)-1)*24+3003)
  </code></pre>
  
  <p>This gives me an <code>error</code>.</p>
  
  <p><img src="https://preview.ibb.co/m5OO2J/excel.png" alt="error"></p>
  
  <p>Thanks for any help.</p>