title: Google Sheets formula query an array based on matches from another array
body: <p>I would like to filter/query Columns A:B based on 1 or more values in Column E.</p>
  
  <p>Essentially, I want to Return values from ColB for any values within ColA which appear in ColE.  I wish I could use this:</p>
  
  <pre><code>=query({$B$1:$C$101},"select Col2 where Col1='" &amp; {$E$2:$E$101} &amp; "'")
  </code></pre>
  
  <p>But, using an array {$E$2:$E$101} for the values to match doesn't work within a query. Here is a link to my spreadsheet:</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1fUixRqqOYh6LleMkvgJdmp7yg2YqOnfzjuHB3glMBKY/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1fUixRqqOYh6LleMkvgJdmp7yg2YqOnfzjuHB3glMBKY/edit?usp=sharing</a></p>
  
  <p><a href="https://i.stack.imgur.com/BkxCa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BkxCa.png" alt="picture of a spreadsheet"></a></p>