Question

Locked

Excel 2003 Question

By vortex138 ·
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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Yes, it's possible....

by ThumbsUp2 In reply to Excel 2003 Question

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.

Collapse -

Thank you!

by vortex138 In reply to Yes, it's possible....

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

Related Discussions

Related Forums