Tornado,

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

HTH,
Bernie
MS Excel MVP

"Tornado" wrote in message
...
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.