title: INDIRECT function not recognizing the range of cells
body: <p>I've been trying to construct an INDIRECT formula. Here's the formula that I've created:</p>
  <pre><code>{=INDIRECT(&quot;D&quot;&amp;ROW(A5)&amp;&quot;:H&quot;&amp;ROW(A5))}
  </code></pre>
  <p>The problem is that the INDIRECT function doesn't recognize the range of cells (i.e., D5:H5). The goal is to get the list of values, but it only extracts the first entry (i.e., D5). Can anyone tell me if I'm missing an important rule for INDIRECT here? Thank you.</p>