Forum Discussion
Formulas / Data Bases
Is there a way to create a data base or formula of employee ID numbers in Excel that would auto-populate the employee's name in the next column when the employee ID number is entered? Thank you.
1 Reply
Hi Lisa,
You can do that, but you have to have an existing table contains employees information.
Once you got this table, you can query from it using a formula such as https://support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1.
The below example illustrates this for you, please find it in the attached file.
Try to change the Employees ID in the query form and see how it works.
