Select a name from a list of employees using Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a macro that extracts soc. sec. # from a list of employees once I
write Last Name of Employee. I used Index & Match commands but my problem is
that employees may share the same last name, even same first name like father
and son. I even tried the VLookup command. How do I go about getting it
right.
Example, If last name is found more than once, then write first name and if
found more than once, write prefix like Jr. or Sr. to distinguish, else write
soc. sec. #.
Thanks in advance.
 
Tornado,

Use another column for key data, which could be LastNameFirstNameSuffix and
look up your data based on that.

HTH,
Bernie
MS Excel MVP
 
Back
Top