Partial Match of Names

Closed
Report
-
 bob -
Hello,

On Excel, I have two seperate spreadsheets. The first is with a list of names, and the second with a list of names and emails. The second list contains a complete list of names (column A) and email addresses (column) - but I do not want the whole thing, only the ones that are on the first spreadsheet. Hence I would like to just get the emails using the first list. Also, I am not sure if the names on the first list are an exact match of those on the second list, so is there such thing as a partial match?

Could anyone describe how to go about doing this?

Thanks in Advance.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
no answer here