macro to do vlookup with multiple results

[mark888]

Hello Girls/Guys,

Appreciate your help once again. I have a macro below but it does not seem to work. Basically i'm trying to get multiple values from Column C if it matches Column B. As I know using Vlookup only returns the first result so tried with this macro but still does not work. Is there any other macro which can help with this?



Color Name
Red Adam
Green Adam
Blue Adam
Red Bob
Green Bob
Yellow Bob
Red Carl
Blue Carl

Result should be below in Column D & E once Macro has run

Color Name
Red Adam, Bob, Carl
Green Adam, Bob
Blue Adam, Carl
Yellow Bob

Hopefully someone can help me with this. :-)

Kind Regards,
Mark.

[spitfireblue]

Hi,

Here is a macro that can do it for you:

Please Login or Register  to view this content.

[spitfireblue]

You can build a function like this, but it is a bit slow. Maybe someone else has a better way:

Please Login or Register  to view this content.

[mark888]

Hi,

Here is a macro that can do it for you:

Please Login or Register  to view this content.

Hello SpitFireBlue,

That works wonderfully. You my good sir, are truly a genius. Thanks for your help. :-)

Kind Regards,
Mark.

[mark888]

You can build a function like this, but it is a bit slow. Maybe someone else has a better way:

Please Login or Register  to view this content.

Hello SpitFireblue,

have no idea how to use the function. :-(
I think the macro actually helps a lot. It can help me to do vlookups with multiple values returning instead of the first one.

Kind Regards,
Mark.

[spitfireblue]

Hi Mark,

Glad I could help

Here is an example of how the function would work. It is basically a user defined formula in cell E2

Function Example.xlsm

[mark888]

Hi Mark,

Glad I could help

Here is an example of how the function would work. It is basically a user defined formula in cell E2

Attachment 458931

Hi SpitFireBlue,


Wow this works as well. Thank you once again for providing me with this alternative sir. Really helps out my work a lot!!!:-)

Kind Regards,
Mark.