+ Reply to Thread
Results 1 to 6 of 6

Employee ID matching

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    4

    Employee ID matching

    Pic.JPGDear Experts,

    I have a data sheet as shown below. Colum A has the master employee ID (some 5000 numbers)followed by Last name and First name in colum B and C. In colum D i have some 1000 ID's only. I need to find the corresponding last name and first name. Kindly refer the attachment

    A B C D E F

    Emp ID Last Name First Name Emp ID Last Name First Name

    123 Jack Jill 234 To be found To be found
    234 Mack Phill 456 To be found To be found
    345 Vamp Jones 567 To be found To be found
    456 Shril Ricard 123 To be found To be found
    567 Raj Kumar 345 To be found To be found

    Kindly let me know, how to proceed.

    Rgds
    Melvin
    Last edited by dsqboy; 03-26-2013 at 12:41 PM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Surrey, UK
    Posts
    5,062

    Re: Employee ID matching

    so in yourexample

    you have ID 123 for Jack Jill in A,B & C
    then in D
    you have ID 234
    now you want to put last name in cell E and first name in Cell F for employee IF 234

    so the resukt would be
    123 - Jack - Jill - 234 - Mack - Phill

    use a vlookup

    in E2 put =vlookup(D2, $A$2:$A$5000, 2, false)
    in F2 put =vlookup(D2, $A$2:$A$5000, 3, false)

    that will return an error if no id found - so we need a bit of error handling - so what happens if there is no ID in D column and what happens if the ID in cell D2 is not found

  3. #3
    Registered User
    Join Date
    03-26-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Employee ID matching

    Hi etaf,

    I have updated the pic, kindly have a look. The range 5000 i gave is approximate. I might have different range every time.

  4. #4
    Registered User
    Join Date
    03-26-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Employee ID matching

    Hi etaf,

    I tried your formula, it not working. Kindly help me. I have attahced pic

    Pic.JPG

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Surrey, UK
    Posts
    5,062

    Re: Employee ID matching

    sorry change the range i only used A - should be A to C
    in E2 put =vlookup(D2, $A$2:$C$5000, 2, false)
    in F2 put =vlookup(D2, $A$2:$C$5000, 3, false)

    see attached
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-26-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Employee ID matching

    Thank you....it workes

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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