Looking up a comma separated column using another comma separated column

Hi All

I have a bit of a tricky one here which I'm having a lot of trouble with. I think it may need a VBA solution.

Anyways, I have 2 columns - ColA which has comma separated email addresses and ColB which has the associated user IDs.

I want to look up each of the comma separated values (user IDs) in ColB to see if they exist in ColA as part of the email address.

If one or more of the user IDs are found in ColA, I need them to be placed in ColC, again as comma separated values. If not found, I need them to appear in ColD as comma separated values.

An example of the result I need is below. I'm hoping someone is able to help me with this.

Thanks
Darls15


ColA
"[email protected],[email protected],[email protected],[email protected],[email protected]"

ColB
klmno3,uvwxy5,zepse5,abcde1,oserc7

ColC - FOUND
klmn03,uvwxy5,abcde1

ColD - NOT FOUND
zepse5,oserc7

Thought id add a basic loop option...

Please Login or Register  to view this content.