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!