Vlookup and return multiple values

**shreeja178** · 07-22-2014, 05:11 AM

Hi, Please help with a formula to vlookup and return multiple value in a single as per the attachment.

Thanks
Shreeja

**excelliot** · 07-22-2014, 05:58 AM

Hi

check this..

Cheers!!

**shreeja178** · 07-22-2014, 07:05 AM

Hi excelliot, thanks for the code. this function is good. but when applied to large number of rows, it gets really slow.
could you suggest a excel formula for this?

**Punnam** · 07-22-2014, 07:14 AM

@ excelliot

HI
is MYVlookup is a extra addin ? or extra feature in 2010 ?
Punnam

**Glenn Kennedy** · 07-22-2014, 08:11 AM

Do the results REALLY have to be in one cell? Is this an acceptable alternative?

**shreeja178** · 07-22-2014, 08:40 AM

Hi Kenneddy, this looks good.. may be i will concatenate the result to a single cell.
Thanks for the help.

**Glenn Kennedy** · 07-22-2014, 08:47 AM

If you're OK with the result, please mark the thread as solved and (preferably) say thanks to those who helped by clicking the Add Reputation button at the foot of their post(s).