title: Using IMPORTRANGE as an array formula
body: <p>I have a URL in one cell which is the criterion for the IMPORTRANGE. e.g.:</p>
  
  <pre><code>=IMPORTRANGE(B2,"sheet1!$A$1")
  </code></pre>
  
  <p>I found a formula to collect it as criterion, but not in array version. </p>
  
  <p>A sample can be found <a href="https://docs.google.com/spreadsheets/d/1yctlfcZHQtekYdn_jBXZBCj6WrHID-nBI0jJaUtVYAg/edit?usp=sharingthanks/shlomo" rel="nofollow noreferrer">here</a>.</p>