title: Filter a range by array
body: <p>I have a Google Spreadsheet containing the teams of the UEFA EURO 2012, and their scores:</p>
  
  <pre><code>Team     Points  Goals scored
  ------   ------  ------------
  Germany    6          3
  Croatia    3          3
  Ireland    0          1
  ...       ...        ...
  </code></pre>
  
  <p>Now I want to filter that list, so that the result contains only a subset of the teams involved. Specifically, I want the resulting list to contain only the teams <em>Germany, Netherlands, Portugal, Italy, England, France, Spain</em> and <em>Croatia</em>.</p>
  
  <p>I know I can use the <code>FILTER</code> function to extract a single value from the table. Thus, I could probably write a <code>FILTER</code> expression like <code>=FILTER(A2:C; A2:A = 'Germany' OR A2:A = 'Netherlands' OR A2:A = 'Portugal' OR ...)</code> but I would like to avoid this, as the list of teams is sort of dynamic.</p>
  
  <p>So the question is: How can I filter the table by a <strong>range</strong> of values - not just a single value?</p>