View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ivory_kitten ivory_kitten is offline
external usenet poster
 
Posts: 40
Default return array formula lookups in to one single cell

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!