I have 2 worksheets, one with a list of names of people who registered for an event, and one with a list of names for those who actually turnedup. I am trying to find a formula to Check one worksheet against the other and bring back YES if the name is on both lists. The names are split into first name and surname