i have copied the technique described he
http://office.microsoft.com/en-us/ex...260381033.aspx

and the formula is working, listing the multiple matches in subsequent rows

however due to varying amounts of data for each lookup, i am wondering how
to go about combing all the values in to one cell, separated by commas?

so instead of saying:
Ashish 234
534
834

it would say
Ashish 234, 534, 834

i do not want to use VBA.

Thanks!

Hello,

IMHO not possible without VBA because CONCATENATE cannot concatenate
arrays.

I suggest to use my UDF Cfreq:
http://sulprobil.com/html/cfreq.html

Regards,
Bernd

Here's one approach but it does require VBA.

http://www.mcgimpsey.com/excel/subs/...mergeselection

--JP

On Sep 25, 10:52*am, ivory_kitten
wrote:
i have copied the technique described hehttp://office.microsoft.com/en-us/ex...260381033.aspx

and the formula is working, listing the multiple matches in subsequent rows

however due to varying amounts of data for each lookup, i am wondering how
to go about combing all the values in to one cell, separated by commas?

so instead of saying:
Ashish * * 234
* * * * * * * * 534
* * * * * * * * 834

it would say
Ashish * *234, 534, 834

i do not want to use VBA.

Thanks!

Hi,

You may use the MCONCAT function. Please note that the mconcat function can
be used only after downloading and installing this add-in -
http://www.download.com/Morefunc/300...-10423159.html

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ivory_kitten" wrote in message
...
i have copied the technique described he
http://office.microsoft.com/en-us/ex...260381033.aspx

and the formula is working, listing the multiple matches in subsequent
rows

however due to varying amounts of data for each lookup, i am wondering how
to go about combing all the values in to one cell, separated by commas?

so instead of saying:
Ashish 234
534
834

it would say
Ashish 234, 534, 834

i do not want to use VBA.

Thanks!

Hello,

Using a "non-open source" add in?

That is my number 1 "Don't":
http://sulprobil.com/html/excel_don_ts.html

Regards,
Bernd