Employee Database
Hi all,
I was wondering if there is a way to combine an employees name with his code.
This is what I got:
One Excel Worksheet, Sheet1 has the names and their code (A1, B1).
Sheet2 is a form where employees obligate tools.
My idea is when I type their code in the form that it automatically fills their name.
Attached is an example file.
Last edited by longchamp; 09-27-2019 at 06:55 AM.
.
Look at VLOOKUP
Great, thanks for the quick reply!
.
You are welcome.
Hi there,
See if the attached version of your workbook does what you need.
It uses the following formula in Cell B2:
It also uses data validation in Column A so that you can select the Employee Id's from a dropdown list.
Please Login or Register to view this content.
Hope this helps - please let me know how you get on.
Regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks