troubleshooting Question

Need advice on how to merge two Excel spreadsheets

Avatar of JadeComputerGal
JadeComputerGalFlag for United States of America asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
9 Comments1 Solution1245 ViewsLast Modified:
I have an Excel spreadsheet that has all the information I need for a project, other than one piece. That piece of information is on a separate spreadsheet. Column A on spreadsheet one has the same values as column A on the spreadsheet two, though not in the same order, and there are many rows on spreadsheet two that aren't required on spreadsheet one. Column A is the only one where the two spreadsheets contain common values.

I am not proficient with Excel and haven't been able to figure out how to merge the two. I need a way to have column A on both spreadsheets matched so the values from column F will appear on spreadsheet one, in the correct rows.

Apologies if this doesn't make sense, and please let me know if more information is needed.
ASKER CERTIFIED SOLUTION
jeverist

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 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 1 Answer and 9 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