Need a Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 17 Oct 2006 00:00 GMT

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

Reply to this Message

Pete_UK - 17 Oct 2006 00:08 GMT

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

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message