How to extract matching data in 2 diferent work sheets
Posted on 2012-09-10
I have taken all my email addresses from my outlook and imputed them in to an excel spreadsheet. I have another spreadsheet with all my customers and their email address. I know my outlook email address are up to date and need to match the correct email address with the customer number. I can do a =VLOOKUP(E2,[Emails.xlsx]Sheet1!$A:$A,1,true) and it returns the matching emails but keeps adding the same email to the next 4 or 5 records until it finds another match. When I use False it returns #N/A for all records. Any help with this. Thank you.