title: How to insert values to a column(ExamPassed) based the content of another column?
body: <p>I have a sheet which contains data like this:</p>
  
  <p><a href="https://i.stack.imgur.com/WauVP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WauVP.png" alt="enter image description here"></a></p>
  
  <p>Now 3 people(Jane, George, and Ryan) inside this table passed the exam. </p>
  
  <p>I want to set their <code>ExamPassed</code> value to <code>v</code>. How can I do this with excel formulas?</p>
  
  <p>I mean at the end of this operation. The table will look like this:</p>
  
  <p><a href="https://i.stack.imgur.com/whJ9g.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/whJ9g.png" alt="enter image description here"></a></p>
  
  <p>The 3 people's names are stored in another table like this:</p>
  
  <p><a href="https://i.stack.imgur.com/ptdWK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ptdWK.png" alt="enter image description here"></a></p>