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.