research Question

Is there any way to lookup matching rows in two different excel files based on data

Avatar of Sal Overmars
Sal Overmars asked on
Microsoft OfficeMicrosoft ExcelSpreadsheetsSSIS
4 Comments2 Solutions25 ViewsLast Modified:
Hello,
I received two different Excel files from a client and I have to match the data with what we have in our system. which i exported to excel files too.. the files received have different naming for the columns so I have to look at the data and go compare it with what I have then figure out if this is the right column. I been doing it manually but I know there must be a better way to approach this but not sure how? can you please help?
Thanks!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros