title: Find and copy a row in Google Sheet
body: <p><strong>Sheet 1</strong></p>
  
  <p>There are items in columns A - F. How do I use VLOOKUP to find a row and copy it to Sheet 2 when it matches criteria in column F?</p>
  
  <p>This is the formula in a cell on Sheet 2: =VLOOKUP(apple,Sheet1!A:F, 2, FALSE)</p>