Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Address List in Excel | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Using excel to select only matching images... | Excel Discussion (Misc queries) | |||
How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) |