I have to fill out spread sheet with different peoples names. It would be easiler for me to input their 5 number employee number. Is there a way to input a id number into a cell, and have it put the persons last name there instead? For example, I would put 12345 in an cell and the name Smith would appear. Thanks for any and all help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
have a word replace a number in a cell
- Thread starter prsmith99
- Start date
It Could be done via a macro.
But honestly easier to have one big table with all the empoyee numbers in it and use a vlookup to that table to put the employee name in the next column.
So Col A would have the employtee number which you input.
Col B would have a VLOOKUP command that puts the Employee name in COl B.
But honestly easier to have one big table with all the empoyee numbers in it and use a vlookup to that table to put the employee name in the next column.
So Col A would have the employtee number which you input.
Col B would have a VLOOKUP command that puts the Employee name in COl B.
Upvote
0
PA HS Teacher
Well-known Member
- Joined
- Jul 17, 2004
- Messages
- 2,838
If the employee id numbers are unique, a table and a vlookup is probably your best best.
In F2 below:
=VLOOKUP(E2,A1:C10,2,0)
In G2 below:
=VLOOKUP(E2,A1:C10,3,0)
In F2 below:
=VLOOKUP(E2,A1:C10,2,0)
In G2 below:
=VLOOKUP(E2,A1:C10,3,0)
Upvote
0
