Vlookup pulling two cells or more of text into one cell separated by a comma

9:27am
Ginni Breault
hi all. I have a Table that contains that may have duplicates in column A, which is my lookup value, but in column B there are different text strings. I need to place the text in column B into one cell like this: "Text 1", "Text 2". I tried to use & but it just repeated the first instance of my lookup value. I need the vlookup to scan down the column and reture each value in column B. Does that make sense?

That's what I mean! I will have
1/12. "The Ghost"
1/13 "The Zombie
1/12. "The Bike"

and what I need on my single cell is the values of A. Right now my Vlookup stops at the first A and I get "The Ghost" when I need: "The Ghost", "The Bike" in 1 cell

The attached file shows how you can do it with formulae. Column C contains a formula to give a unique reference to each record (I've hidden this), and the formula in G2 enables up to 3 multiples to be displayed (although it can easily be extended for more) - just change the lookup value in the yellow cell.

Hope this helps.

Pete

I am thrilled with this! I will be attempting to make it work in my calendar tomorrow, and I am sure it work. This is brilliant!

Thanks so much

@bradbracey

Read the Forum Rules at the top of the screen - you should not ask a question in someone else's thread, so start your own instead.

Pete