title: Excel - Check if two values exist together in two columns
body: <p>I want to be able to check if user in <code>B2</code> has access to applications in <code>A3:A6</code>.</p>
  
  <p>I have a list of all users and what they have access too, how will I be able to match and compare both lists and place a Yes or No in the table?</p>
  
  <p>Please see the example from the screenshot below:</p>
  
  <p><img src="https://i.stack.imgur.com/9gSCf.png" alt="Example"></p>
  
  <p>I've had a look at <code>VLookups</code> etc but any help wouldn't go a miss! </p>