Hello everyone,

I have those two colums in my worksheet:

37257.00 peanuts
37257.00 banana
37257.00 coconut
37258.00 gold
37258.00 coal

I would excel to sort the data this way:

37257.00 peanuts,banana,coconut
37258.00 gold,coal

I am trying to use VLOOKUP along with CONCATENATE, but my problem is
that VLOOKUP only returns one value ("peanuts") :(

This is what I am writing something like this:
CONCATENATE(VLOOKUP(37257,'(data)'!A:D,4,TRUE),"," ,VLOOKUP(37257,'(data)'!A:D,4,TRUE),",",VLOOKUP(37 257,'(data)'!A:D,4,TRUE))

Is it possible to have VLOOKUP to return peanuts, banana and coconut in
the same cell?

Many thanks,


--
duration
------------------------------------------------------------------------
duration's Profile: http://www.excelforum.com/member.php...o&userid=35846
View this thread: http://www.excelforum.com/showthread...hreadid=560159