title: Follow formula patterns for some cells only
body: <p>I am trying to get excel to follow patterns grabbing information from cells only, while keeping other cells in the formula static.</p>
  
  <p>As follows:</p>
  
  <pre><code>=importxml(CONCATENATE(A1,B17),E1)
  </code></pre>
  
  <p>A1 = never changes</p>
  
  <p>B17 = increments by 1 every time. Ex: B17, B18, B19, etc...</p>
  
  <p>E1 = never changes</p>
  
  <p>Right now it seems like excel is counting the number of cells from the cell I am currently in and once I try to follow that pattern it keeps counting the same number of cells to grab the cell in the pattern. (Ex: 7 cells up, so as I move down from the current cell it keeps looking for data in the cell 7 cells up from the current one, which is often, empty). Moreover, right now all cells are changing in the pattern and I only need SOME cells to follow the pattern.</p>
  
  <p>I appreciate any help with this.</p>