I need help performing a multi-column comparison. the "Registrants" sheets contains a fictitious list of people that registered for an event. The "Employee List" sheet contains a list of employees exported from an information system. I'd like the third sheet, "Validated" to list the first name, last name, and date of birth, of all rows in "registrants" that are also present in "employee list." When performing the comparison, only last name and date of birth should be compared.The fourth sheet, "Additional Validation needed - no match" should contain all rows within "registrants" that do not have a last name and date of birth match in "employee list". I've tried multiple formulas but cant figure this out. your help is appreciated.
Bookmarks