Avatar of DJ P
DJ PFlag for United States of America asked on

Excel 2016 Comparing two cells to populate a third cell

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.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
DJ P

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Shaun Kline

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
DJ P

I pasted you suggestion per your instructions and all it did was remove Test1 record from cell B2.
ASKER
DJ P

Thanks. I understand it now.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck