Combining Vlookup and concatenate...in a way...

[metube]

I have this table that has a category or brand and products, for example:

A B
Gillette Shampoo
Gillette Conditioner
Gillette Shaving Gel
Dove Soap
Dove Cream

I was looking for a function that has the ability to lookup the values for Gillette and then in the next cell have "Shampoo, Conditioner, Shaving Gel".

I found a function called MCONCAT thats available with a plug in, but this is for work and I can't d/l add-ons.

Its sort of a silly function, but I would be very appreciative if anyone had the answer.

Thanks!

 

[Dryver14]

have you tried text to columns?

use fixed width

 

[Aladin Akyurek]

I have this table that has a category or brand and products, for example:

A B
Gillette Shampoo
Gillette Conditioner
Gillette Shaving Gel
Dove Soap
Dove Cream

I was looking for a function that has the ability to lookup the values for Gillette and then in the next cell have "Shampoo, Conditioner, Shaving Gel".

I found a function called MCONCAT thats available with a plug in, but this is for work and I can't d/l add-ons.

Its sort of a silly function, but I would be very appreciative if anyone had the answer.

Thanks!

How about using the work-alike ACONCAT whose code can be found at this board?

 

[metube]

Thanks for the heads up!

I will try the AConcat func in the morning