Partial Match of Names

Jordan - Jul 27, 2010 at 03:24 PM
 bob - Jul 24, 2015 at 05:59 PM

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

Registration date
Thursday January 28, 2010
Last seen
May 5, 2022
Jul 30, 2010 at 08:31 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like ,, , 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