title: =QUERY syntax when working with data submitted via Google Form
body: <p>The Query below 'works' on a line by line basis (when manually filled down), but it does not 'autofill' down when new data is added to the 'responses sheet'. The data being added to the 'responses sheet' comes from a Google form.</p>
  
  <pre><code>=QUERY(Sheet2!$A$1:K; CONCATENATE("SELECT B, C WHERE A = ", responses!B1), 0)
  </code></pre>
  
  <p><strong>Question</strong><br>
  <strong>One</strong> - How do I adjust this Query so it will 'autofill' down when new data is added to the 'responses sheet' by a Google form?</p>
  
  <p>If this is not possible, any suggestions?</p>
  
  <p><a href="https://docs.google.com/spreadsheet/ccc?key=0AhNVNg1xSJ6-dGpvdFJGMmpuWExWeUE2SWhFQ21Wb3c&amp;usp=sharing" rel="nofollow">Here is a link to the Google Spreadsheet I'm working with</a></p>
  
  <p>Thank you for your time and assistance,<br>
  Todd<br>
  High School Teacher</p>