Hello all,

I am new to this forum and in search of a solution to my excel problem. I have two files at issue: Master and Specific. Master has a list of 5000 names, addresses, phone numbers, etc. The names are sorted by last name and first name, but the first name is preceded by "Mr." or "Ms." (i.e., Doe, Mr. John). Specific has a list of names that are NOT separated by first and last name, but rather are combined (i.e., John Doe, instead of John, Doe).

I need to extract the data from Master that corresponds with Specific. It doesn't necessarily have to be extracted into the Specific file, I just need the names that are on specific (1000 or so) with the full information that is on the Master file.

Thank you in advance for the help. Please let me know if you need any additional information. If it makes you feel any better, this is for a charity event my university is holding. I got stuck with getting the invitations together.

Many thanks!