title: Query with range of values for WHERE clause?
body: <p>I have a Google Spreadsheet and I want to run a <code>QUERY</code> function. But I want the <code>WHERE</code> statement to check a series of values. I'm basically looking for what I would use an <code>IN</code> statement in SQL - what the <code>IN</code> equivalent in Google Spreadsheets? So right now I have:</p>
  
  <pre><code>=QUERY(Sheet1!A3:AB50,"Select A,B, AB WHERE B='"&amp; G4 &amp;"'")
  </code></pre>
  
  <p>And that works. But what I really need is the equivalent of:</p>
  
  <pre><code>=QUERY(Sheet1!A3:AB50,"Select A,B, AB WHERE B='"&amp; G4:G7 &amp;"'")
  </code></pre>
  
  <p>And of course, that statement fails. How can I get the where against a range of values? These are text values, if that makes a difference.</p>