title: Return array from INDEX function in Excel?
body: <p>I'm trying to use INDEX in array format in Excel but I'm running into problems.</p>
  
  <p>From this question: <a href="https://stackoverflow.com/questions/13868867/return-array-from-index-function">Return array from INDEX function?</a>, it seems that "INDEX (like VLOOKUP) doesn't return an array of values (except in some convoluted circumstances)"</p>
  
  <p>So I'm wondering what alternatives there are. </p>
  
  <p>I'm trying to do this:</p>
  
  <pre><code>=qlTimeSeries( ,
                 INDEX({39618,39619,39638,39639},{2,3,4}),
                 INDEX({18,19,38,39},{2,3,4})
                 )
  </code></pre>
  
  <p>and Index is not returning an array.</p>
  
  <p>Any alternative idea how to get the result I am trying to get with INDEX({39618,39619,39638,39639},{2,3,4})?
  i.e. from {39618,39619,39638,39639} get {39619,39638,39639} back?</p>
  
  <p>NOTE: Instead of INDEX({39618,39619,39638,39639},{2,3,4}) my spreadsheet in fact uses a dynamic array of dates and the objective is to drop the first element of the array {39618,39619,39638,39639} which is why I am using INDEX.</p>
  
  <p>EDIT: Looking for a solution that avoids using VBA</p>