return array formula lookups in to one single cell

I

ivory_kitten

i have copied the technique described here:
http://office.microsoft.com/en-us/excel/HA012260381033.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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summating vlookup or index formulas 5
vlookup one value and return multiple values 3
How to look up a value in a list and return multiple corresponding values 7
Use array for lookup value, to return array of lookups 4
Return a list of cells based on data in a single cell. 4
How to supress #N/A in an array formula. 5
Lookup Mulitple Values, Return Results in One Cell 6
How to return the row # of an expression in specific array of cell 2

Top