Use lookup to return values separated by comms

[cnsxad]

Good morning!

I am new to the forum and have a problem that I need help to solve. I am not proficient with formulas, macros and advanced excel stuff.

I have a sheet with values in a cell separated by commas. I need to change those values to another set of values given to me and retain that they are separated by commas.

I have attached an example. Sheet named "Data" are my original values. Sheet named "Lookup table" is such. Sheet named "Result" is what I need my answer to be.

I would appreciate any assistance. Thank you!

[DonkeyOte]

You have a few options but my first question to you would be:

What is the max number of conditions that could be present in any one cell ?

[cnsxad]

I am glad to hear that there are a few options.

The maximum number of conditions would be 13. They could have all of the values listed except for "None".

[DonkeyOte]

From what I can see someone's already tried to give you a solution which with 2 minor amendments will work.

Amendment 1:

In your file: go into VB Editor.
Go to ThisWorkbook
Cut the Text from that Page and Paste into Module 1.

Amendment 2:

Change this line:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

Now go back to Native XL and to Sheet Data

In Cell B2:

=MultiVLookup2($A2,'Lookup Table'!$A$1:$B$20,2)

[cnsxad]

I hope that you don't get offended by this but I have to say
"God Bless you!"

I am new to VBA and could not figure out what was wrong with the multilookup function and I thought that I had deleted it out before posting the example. You have saved me sooo much headache and time!! I hope that you have a wonderful rest of the day!!