Hi All!
I am trying to create or use a formula for the below scenario.
On an excel workbook, I have two sheets. Each have various identifiers or entity numbers. The first sheet is the formal sheet that is supposed to pair the entity numbers to employee names. The entity numbers are in ascending order. The employee names are blank.The second sheet has the matching numbers and corresponding employees. My task is to create a formula or function that matches the entity and fills in the corresponding name. For example, if I am needing to find out who works 118 site, I will pull 118 from sheet two and have the name appear next to the number in the first sheet.
Bookmarks