• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup Table array column is text string coma delimited

S

SRajender

New Member
Hi friends i want to lookup where the cell contain a text string with multiple values coma seperated.

I have Table1 and Table2,
Table1.Col1 has unique values which i want to lookup in Table2.clo1 and bring in Table2.clo2.

The challenge here is Table2.Col1 is text string with multiple values of Table1.Col1 seperated using a coma.
 
Can you use the Text-to-columns feature to split your data up into the correct numbers of columns? This will make things much easier.
 
You must log in or register to reply here.
Back
Top