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
Bookmarks