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 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