ExcelBanter - Need a Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need a Function (https://www.excelbanter.com/excel-worksheet-functions/114690-need-function.html)

Hi,

I need a fucntion that can lookup a value and pull out corresponding
information (that resides in multiple cells for that value) and paste that
information into one cell seperated by commas. Is there a functionthat
accomplish this?

Thanks

Seems a strange request - Vlookup can return a single value relating to
a fixed number of columns to the right of the lookup value, so you
could have something like this:

=vlookup(a1,table,2,0)&","&vlookup(a1,table,3,0)&" ,"&vlookup(a1,table,4,0)&","&vlookup(a1,table,5 ,0)

and so on, to get you the results from the second, third, fourth, fifth
column of your table.

Hope this helps.

Pete

Richard wrote:
Hi,

I need a fucntion that can lookup a value and pull out corresponding
information (that resides in multiple cells for that value) and paste that
information into one cell seperated by commas. Is there a functionthat
accomplish this?

Thanks