title: Meeting two conditions to display a column from another page
body: <p>I'm attempting to meet two conditions so that I can display a column from one spreadsheet to another. The two conditions are that the date matches and that the persons' name matches. Once these two are met, a column that shows the employees reply from the page <code>Form Responses</code> would display onto another spreadsheet that's more compact.<br></p>
  
  <pre><code>=IF(and('Form Responses 1'!B2:B=A7,
          'Form Responses 1'!E2:E="John Smith"),
          'Form Responses 1'!F2:F," ")
  </code></pre>
  
  <p><code>'Form Responses 1'!B2:B</code> would be the date from the first spreadsheet.
  A7 would be the date in the compact spreadsheet</p>