troubleshooting Question

Excel 2016 Comparing two cells to populate a third cell

Avatar of DJ P
DJ P asked on
Microsoft OfficeMicrosoft Excel
3 Comments1 Solution43 ViewsLast Modified:
Good afternoon experts. I do not work with excel so I am in need of some assistance. I have attached a sample file that contains test data in sheet 1 and sheet 2. What I need to have happen is to compare the data in sheet one column a (Level1) against sheet 2 column a (Proj_ID) and if there is a match auto populate sheet 1 column b (proj_mgr_name) with the appropriate name in sheet 2 column b (PROJ_MGR_NAME).

So for example in sheet one the first record is 10230 in sheet 1. In sheet 2 record 10230 is assigned to proj_mgr_name Test777
I would need Test777 to auto populate in sheet 1 column b (Project Manager)

I have zero clue how to accomplish this. I hope this makes sense. Any help would be greatly appreciated.
Shaun Kline
Lead Software Engineer

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 3 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 3 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