# Employee ID matching

1. ## 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

2. ## 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. ## 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. ## Re: Employee ID matching

Hi etaf,

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

Pic.JPG

5. ## 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

6. ## Re: Employee ID matching

Thank you....it workes

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

#### 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