Question

  • Creator
    Topic
  • #2151566

    Excel 2003 Question

    Locked

    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!

All Answers

  • Author
    Replies
    • #2925924

      Clarifications

      by vortex138 ·

      In reply to Excel 2003 Question

      Clarifications

    • #2925913

      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.

      • #2927157

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

Viewing 1 reply thread