• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 401
  • Last Modified:

How to extract matching data in 2 diferent work sheets

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.
1 Solution
It often happens that the data contain some extra spaces or other whitespace at the end which will prevent an exact match.  The approximate match (true in the last param) would work because it assumes the data is sorted and returns the previous record, which in this case is the correct one for the matches.  Try using the TRIM function on the data, then copy and paste special values back to clean it.  If that doesn't work, please post the sheet so we can take a look.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now