I need to match last names and dates of birth to return an account number. I have found a solution previously in the forums, but can't seem to find it now!
I have two sheets, one that has a BUNCH of people listed, their names, their dates of births and their account numbers. The other list has the last names and dates of birth, but no account numbers. I need to match the last names and dates of birth to return the account number. Example attached!
Bookmarks