Areallusernamestaken
New Member
- Joined
- Apr 16, 2021
- Messages
- 44
- Office Version
- 365
- Platform
- Windows
- Web
Hi,
Thanks in advance for your help through this amazing forum! I wish I could be more help to others here!
I am trying to fill in Employee IDs in column A by pulling them from a separate list based on names.
I have the following formula, which pulls ID numbers from a separate list based on names: =TRIM(IFERROR(INDEX(separate list column A,MATCH(RIGHT(B2,LEN(B2)-FIND(" ",B2))&", "&LEFT(B2,FIND(" ",B2)-1), separate list column B,0),1),"Fill in"))
CURRENTLY,
Active sheet:
A B
Separate List:
CURRENTLY, the list it's pulling from (Separate List) has the names listed like this: Last, First
while the active sheet has the names listed like this: First Last
I now have a NEW Active Sheet where the names are listed Last, First. The Separate List remains the same.
How can I adjust my formula for this new format? I would still like it to look for last name, look for first name, and if it contains both, pull up the matching ID from Separate List. I also don't want it to be thrown off by the presence of a middle initial.
Hope that was clear.
Thank you!
Thanks in advance for your help through this amazing forum! I wish I could be more help to others here!
I am trying to fill in Employee IDs in column A by pulling them from a separate list based on names.
I have the following formula, which pulls ID numbers from a separate list based on names: =TRIM(IFERROR(INDEX(separate list column A,MATCH(RIGHT(B2,LEN(B2)-FIND(" ",B2))&", "&LEFT(B2,FIND(" ",B2)-1), separate list column B,0),1),"Fill in"))
CURRENTLY,
Active sheet:
A B
Emp. ID | Name |
Derrick Domingo | |
Beth Brown | |
| Amber Amigos |
Separate List:
CURRENTLY, the list it's pulling from (Separate List) has the names listed like this: Last, First
while the active sheet has the names listed like this: First Last
I now have a NEW Active Sheet where the names are listed Last, First. The Separate List remains the same.
How can I adjust my formula for this new format? I would still like it to look for last name, look for first name, and if it contains both, pull up the matching ID from Separate List. I also don't want it to be thrown off by the presence of a middle initial.
Hope that was clear.
Thank you!