title: VLOOKUP to compare two columns
body: <p>I am trying to use the result of vlookup and then evaluate the result of another column.
  I have the following two tables:</p>
  
  <p>Roster:</p>
  
  <pre><code>   ID  Current Employee
     12  Yes
     13  No 
  </code></pre>
  
  <p>TableB:</p>
  
  <pre><code>   ID  In Roster &amp; Current Employee
     12  ?
     13  ? 
  </code></pre>
  
  <p>To make the check for if the employee is in Roster, I can do a simple Vlookup: 
  <code>=IF(NOT(ISNA(VLOOKUP(A2,Roster!A:A,2,FALSE))),"Yes","No")</code>
  How do I check the two columns simultaneously to get the result of "In Roster &amp; Current Employee"?</p>