title: How to match names in two sheets?
body: <p>I am using excel to keep track of attendance but i find this very difficult. Is there a way/formula for this?</p>
  
  <p>Problem.
  Sheet 1 column A1-30 will show the list of people for day 1. Contains list of names say (Last name, First name ONLY) 
  Sheet 2 column J1-3000 also contains a list of names but with middle names in it (Last Name, First Name Middle Name)</p>
  
  <p>How can i match two sheets to create a third sheet that will show who attended Day 1?</p>
  
  <p>Thanks a bunch.</p>