• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • 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.

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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