beginvbaanalyst
Board Regular
- Joined
- Jan 28, 2020
- Messages
- 139
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
I've provided a screenshot on what I need help with.
In Column N and O I have names and numbers.
I did an Xlookup to get the names into column E.
Now I want to pull both numbers into column F from column O.
As you can see there is 0221 and 0222.
Is there a way to do this in Column F? There are times when I see multiple numbers under one name.
This would be A HUGE help if someone could help explain how to pull this off.
Thank you.
I've provided a screenshot on what I need help with.
In Column N and O I have names and numbers.
I did an Xlookup to get the names into column E.
Now I want to pull both numbers into column F from column O.
As you can see there is 0221 and 0222.
Is there a way to do this in Column F? There are times when I see multiple numbers under one name.
This would be A HUGE help if someone could help explain how to pull this off.
Thank you.