title: Find and repeat a cell value if values match
body: <p>My spreadsheet is collecting data from a form</p>
  <p><a href="https://i.stack.imgur.com/ckGom.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ckGom.jpg" alt="Responses from Google Form" /></a></p>
  <p>On another tab I'm showing the responses that match &quot;Lesson day&quot; with &quot;Today's date&quot; (in the example, all the lessons are showed).</p>
  <p><a href="https://i.stack.imgur.com/JAoSe.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JAoSe.jpg" alt="Second tab" /></a></p>
  <p>As you can see, the &quot;e-mail&quot; field is filled out only once.
  Is there a way to automatically fill the &quot;e-mail&quot; field in the second tab? Maybe matching the &quot;Student Code&quot; with the &quot;e-mail&quot; fields in the first tab?</p>
  <p>I've tried the MATCH() function but it returns only the position. I feel like I need to combine MATCH() with other functions but I have no idea about where to start</p>
  <p>EDIT: Having the email adresses on another column would work too.
  SOmething like: if the &quot;Student Code&quot; in the 2 tabs matches, show the email adress for that &quot;Student code&quot;</p>