Software

Ask something
Question Locked

Excel 2003 Question

0 helpful
3 replies

by vortex138

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a user who uses an Excel Workbook to track the time sheets of her employees. What she wants to do is have a list of the employees' names and have a number attached to them so that all she needs to do in one of the columns on her spreadsheet is type in the number and have the employee name appear instead of the number. Is this possible in Excel?

Thanks in advance!

3 replies

by thumbsup2

Have the employee create another sheet in the workbook which will be used as a lookup table. The new sheet should contain the number in one column and the employee name in the other column. That sheet MUST be sorted by employee number at all times.

Now, in the regular sheet that she's working in, first make sure there is a column for typing the employee number into. Then, you can either replace the employee name with a VLOOKUP formula, or insert a new column to put the formula into so she can double check the results against the real employee name. Once you have it working properly, the column with the real employee name could be deleted.

When this works properly, she inputs the employee number, Excel goes to that extra sheet and finds the number then returns the employee name next to it, displaying it where the formula is sitting.

by vortex138

Thank you, thank you! I saw the vlook up before, but have never used it. I'll have her get to work it. :)

This discussion is closed to new replies.