title: Using ARRAYFORMULA and INDIRECT to iterate rows and return as a block
body: <p>Sheet1 has columns A to D where A contains a unique record key.</p>
  
  <p>On Sheet2 I want to rearrange the data, against my own sort order. Colum A contains my own custom ordered record keys.</p>
  
  <p>What I have done upto now on Sheet2 is; I'm calculating the record positions in Column B as</p>
  
  <pre><code>=ARRAYFORMULA(MATCH(A1:A100,Sheet!A:A,0))
  </code></pre>
  
  <p>And I have been trying to use ARRAYFORMULA INDIRECT to get the data in one go.
  I can get a single row correctly using </p>
  
  <pre><code>=ARRAYFORMULA(INDIRECT(("Sheet1!B"&amp;B1&amp;":D"&amp;B1)))
  </code></pre>
  
  <p>What I want is something like below, but it still returns the first row ONLY.</p>
  
  <pre><code>=ARRAYFORMULA(INDIRECT(("Sheet1!B"&amp;B1:B100&amp;":D"&amp;B1:B100)))
  </code></pre>
  
  <p>Help.</p>