I've got to send out an e-mail to some folks who attended a meeting. The folks who attended the meeting are a sub-set of an organization. I have addresses for the entire organization in one sheet along with their first and last names in separate columns, and I also have an excel sheet of attendees without addresses.
So vlookup would work if there weren't repeated last names, but there are several Andersons etc. So, how to I logically code a formula that only returns an address if both the first and last names match and are in the same row of the master list?
So vlookup would work if there weren't repeated last names, but there are several Andersons etc. So, how to I logically code a formula that only returns an address if both the first and last names match and are in the same row of the master list?