Thanks for replying. I did try that, but I am looking up a reference # on
another sheet and want all occurances of that reference number's description
to go into one cell on Sheet1.


"Aziz" wrote:

Use the Option Concatenate for three cells to get unique ce name and that
should help

"BeckyB" wrote:

I have various items in a spreadsheet. Some of these items are repeated in
various rows, but have a different text description for it. They all have the
same reference number, just a different description. I want to combine all
the descriptions into one cell. I am doing vlookup, but it is only putting in
the first occurance. Is there a way to combine all descriptions into one cell?