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