split-cane
New Member
- Joined
- Oct 13, 2006
- Messages
- 3
Hi there!
I have two systems at work that use different names for the same people. One uses the full name, the other an abbreviation. On one worksheet column A lists the abbreviated name and column B lists the full name. This is my "conversion" worksheet.
On another worksheet I have a column D, which has multiple instances of the abbreviated names. I want to automatically convert all of those multiple instances of the abbreviated names into multiple instances of the correct full name.
Example of conversion worksheet:
Steve Smith SteSmi
Chris Jones ChrJon
Bob Wells BobWel
Example of data list:
SteSmi ?
SteSmi ?
SteSmi ?
SteSmi ?
ChrJon ?
SteSmi ?
ChrJon ?
BobWel ?
SteSmi ?
SteSmi ?
SteSmi ?
BobWel ?
SteSmi ?
Looking for a formula that can fill in the ? with the correct full name...
Thanks,
split-cane
I have two systems at work that use different names for the same people. One uses the full name, the other an abbreviation. On one worksheet column A lists the abbreviated name and column B lists the full name. This is my "conversion" worksheet.
On another worksheet I have a column D, which has multiple instances of the abbreviated names. I want to automatically convert all of those multiple instances of the abbreviated names into multiple instances of the correct full name.
Example of conversion worksheet:
Steve Smith SteSmi
Chris Jones ChrJon
Bob Wells BobWel
Example of data list:
SteSmi ?
SteSmi ?
SteSmi ?
SteSmi ?
ChrJon ?
SteSmi ?
ChrJon ?
BobWel ?
SteSmi ?
SteSmi ?
SteSmi ?
BobWel ?
SteSmi ?
Looking for a formula that can fill in the ? with the correct full name...
Thanks,
split-cane