title: Is it possible to have array as an argument to INDIRECT(), so INDIRECT() returns array?
body: <p>Suppose, that I have a vector of cells <code>A1:A5</code>, each with string that is an address of the other cell.</p>
  
  <p>What I want to do, is to have a function, that returns <em>an array of values from these referenced cells</em>. See the example - I want the formula to return 15 (it returns 1).</p>
  
  <p><img src="https://i.stack.imgur.com/IdfSG.png" alt="enter image description here"></p>
  
  <p>In production setting, this vector is much longer (ca. 2000 rows). </p>
  
  <p>What would solve the problem, is array-capable INDIRECT(). </p>
  
  <p>(I realize, that I might be pushing Excel beyond its the limits)...</p>
  
  <hr>
  
  <p>My further thoughts on this topic:</p>
  
  <p>Because the INDIRECT() is capable of producing arrays even from a single-cell input, such theoretical "INDIRECTARR()" formula would either require nested (i.e. multidimensional) array computation support in Excel, or will be intrinsically limited to arguments that denote one-dimensional ranges.</p>