Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tornado
 
Posts: n/a
Default Select a name from a list of employees using Excel

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   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 12:46 PM
Address List in Excel getalife Excel Discussion (Misc queries) 2 May 29th 06 04:58 PM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 07:45 PM
Using excel to select only matching images... davidbev008 Excel Discussion (Misc queries) 1 December 3rd 04 08:18 PM
How do I import a Windows Explorer list into Excel? Gord Dibben Excel Discussion (Misc queries) 0 December 1st 04 11:20 PM


All times are GMT +1. The time now is 03:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"