title: ARRAYFORMULA with IMPORTRANGE
body: <p>In column B are listed IDs of Google Sheets. In column C are listed cells, from which I want to import data.</p>
  
  <p><a href="https://i.stack.imgur.com/IxGsS.jpg" rel="nofollow noreferrer">Screenshot of the table</a></p>
  
  <p>In column D is shown the result of using IMPORTRANGE() by simply dragging it. e.g. for D1 it looks like:</p>
  
  <pre><code>=IMPORTRANGE(B1;C1)
  </code></pre>
  
  <p>for D2:</p>
  
  <pre><code>=IMPORTRANGE(B2;C2)
  </code></pre>
  
  <p>and so on.</p>
  
  <p>In column E I want to display the same result but using ARRAYFORMULA that looks like: </p>
  
  <pre><code>=ARRAYFORMULA(IMPORTRANGE(B2:B4,C2:C4))
  </code></pre>
  
  <p>but the function displays only the data from the first spreadsheet.</p>