+ Reply to Thread
Results 1 to 4 of 4

Excel Automatically Insert Employee Number

  1. #1
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    130

    Excel Automatically Insert Employee Number

    Good morning,

    I was wondering if it is possible with excel, to automatically insert an employees number if their name is inserted.

    Example
    Column A If Smith, John is entered in Column B automatically have his employee number show 5668?
    Joe, Mary entered in Column A Column B to show 12345


    This would save me a huge amount of time going back and fourth.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,468

    Re: Excel Automatically Insert Employee Number

    Do you have a separate table listing the employee names and numbers? If so, then a simple VLOOKUP formula could do this for you - post some details of sheet names, columns used etc.

    Hope this helps.

    Pete

  3. #3
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    130

    Re: Excel Automatically Insert Employee Number

    Yes I do. On I copied it into another sheet same workbook. Column A has all the employee names and Column B has their numbers. What would the Vlookup formula be? Also if I apply it to the entire column A. How can I leave it that the is nothing showing in that column until something is entered in column a?

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,468

    Re: Excel Automatically Insert Employee Number

    Put this in B2 of Sheet1, assuming you enter the first employee's name in A2 and that your table of names and numbers is in Sheet2:

    =IF(A2="","",VLOOKUP(A2,'Sheet2'!A:B,2,0))

    then copy down as far as you need to.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. insert missing date per employee
    By uidards in forum Excel General
    Replies: 2
    Last Post: 05-24-2013, 03:27 AM
  2. [SOLVED] how can i insert a blank row automatically into excel when a number is missing
    By seanduffy1 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-19-2013, 09:23 AM
  3. Replies: 3
    Last Post: 09-17-2012, 08:05 AM
  4. [SOLVED] Return employee name when the employee's number is entered
    By Mike in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-16-2005, 03:05 PM
  5. Replies: 2
    Last Post: 08-04-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1