Employee ID matching

**dsqboy** · 03-26-2013, 12:33 PM

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

**etaf** · 03-26-2013, 12:40 PM

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

**dsqboy** · 03-26-2013, 12:46 PM

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.

**dsqboy** · 03-26-2013, 12:53 PM

Hi etaf,

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

Pic.JPG

**etaf** · 03-26-2013, 01:09 PM

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