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?