title: How to reference another sheet in the QUERY function?
body: <p>In short, this doesn't work:</p>
  
  <pre><code>=QUERY(SHEET1!A:E, "where 'SHEET1'!B contains '"&amp;A1&amp;"'")
  </code></pre>
  
  <p>I am shown:</p>
  
  <blockquote>
    <p>unable to parse query string</p>
  </blockquote>
  
  <p>and I can't work out why.</p>