title: I can't use FILTER with ARRAYFORMULA in Google Spreadsheet
body: <p>I realize that there are multiple questions with this title, but I don't understand the answers to them, or it is not directly related to my issue.</p>
  
  <p>I'm trying to avoid manually "dragging" a formula to duplicate it for each row.</p>
  
  <p>The formula looks like this</p>
  
  <pre><code>=FILTER(Companies!A$2:C, Companies!A$2:A="USD", Companies!B$2:B=D2)
  </code></pre>
  
  <p>and it works as well</p>
  
  <p>But when I apply <code>ARRAYFORMULA</code> it shows the same result for each row</p>
  
  <pre><code>=ArrayFormula(IF(ISBLANK(C2:C),, FILTER(Companies!A$2:C, Companies!A$2:A="USD", Companies!B$2:B=D2:D)))
  </code></pre>
  
  <p>I've shared the spreadsheet with all data </p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/15m0nz2JWrVTu6fZj22Zdu1wnF3q7OVTA25DEl2xMR_k/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/15m0nz2JWrVTu6fZj22Zdu1wnF3q7OVTA25DEl2xMR_k/edit?usp=sharing</a></p>
  
  <p>I understand that Filter is an arrayformula but I can't understand how I can get appropriate data from another tab. </p>