How do I associate an employee # to a name in Excel 2007?

30 pts.
Tags:
excel
Excel 2007
Excel 2007 workbooks
Excel formulas
Microsoft Excel 2007
I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell.
Ex: Column A=Employee#, Column B=Employee's name. I want to type in the employee's # in cell A1 and have their name automatically appear in B1.


Software/Hardware used:
Excel 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.

Looks like you could write an Excel Macro, with the employee numbers and names in a different sheet of the same workbook.

For an example writing a macro: Column Name from Column Number for VBA Formula.

Discuss This Question: 10  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Where is Excel going to get the employee name from to put it in B1 ?
    69,045 pointsBadges:
    report
  • Weazel58
    That's the problem. I create another sheet that listed Employee # and name. But how do I associate one with the other?
    30 pointsBadges:
    report
  • carlosdl
    You could use the VLOOKUP function. Try using a formula like this in B1 (assuming that you have your employee #'s and names in Sheet1 of c:\names.xls in range A1:B100):
    =VLOOKUP(A1,'C:[names.xls]Sheet1'!$A$1:$B$100,2,FALSE)
    69,045 pointsBadges:
    report
  • carlosdl
    A backslash was removed by the editor. This would be the formula: =VLOOKUP(A1,'C:\[names.xls]Sheet1'!$A$1:$B$100,2,FALSE)
    69,045 pointsBadges:
    report
  • XENOPHON22
    If you use the VLOOKUP function as Carlosdl suggested, add the names and associated IDs on a different tab in the same spreadsheet. This will help it function markedly faster.
    2,340 pointsBadges:
    report
  • JK0124
    I agree with what AndreaF said... Try to use the Vlookup function if it helps.
    50 pointsBadges:
    report
  • Weazel58
    I added an Employee sheet to the spreadsheet. Column A2-6 is the Employee# and B2-6 is the Employee name. After I type: =VLOOKUP(A2,employee,!$A$2:$B$6,2,false) I'm still getting an error message
    30 pointsBadges:
    report
  • carlosdl
    You have an extra comma after 'employee' in your formula. Also, what cell are you putting your formula in ?
    69,045 pointsBadges:
    report
  • carlosdl
    Good point Xenophon22. However, if this employee look up functionality is going to be used in more than one excel file, it would be recommended to have the employees information in a separate file, to avoid redundance. If this is not the case, then definitely put that information in the same file as suggested by Xenophon22.
    69,045 pointsBadges:
    report
  • Chippy088
    Yes, the look-up function would be ideal for your task, if you want to sum their tips. The main task, as I understand it is to simplify the entry of the staff member when you want to log the tips they have earned, as they earn them. I find typing a regular name or number is best done with a drop down box in a form. It is easier to pick an entry from a list, than to have to type it in without making a spelling mistake, or mistyping a number. Just set it up as a list on an employee sheet, and create a drop down on the daily log sheet, to display it each time you want to enter the tips.
    4,625 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following