Need a Function

R

Richard

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
 
P

Pete_UK

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
 
Top