Lookup and Return Multiple Results into One Cell Separated by Comma or Similar Delimiter

In this video I demonstrate how to lookup and return multiple values concatenated into one cell. This solution is achieved using the following functions: IF, TEXTJOIN and UNIQUE. This works in Excel 365 and partially works in Excel 2016.

This video answers the following queries:
In Excel lookup and return multiple values in one cell.
Lookup and return multiple values concatenated into one cell.
How do I return multiple values in one cell in Excel?
Vlookup and return multiple values in one cell separated by a comma.
How do I Vlookup and return multiple values in one cell?
How do you combine values in a column in a row separated by comma?
Lookup and return multiple values concatenated into one cell.
------------------------

[francisguchie]

Providing a solution to both the 365 and 2016(and above) thank you once again

[LauraLopez-pidd]

EXACTLY what I needed, concise and simple, thanks!

[IvanCortinas_ES]

Very good example and resolution Chester. More used than it seems. Thank you!!!

[KalyanKommanapalli]

Thanks so much for putting this together. I was exactly looking for this use case and I was struggling for a day when I came across your video after going through so many other ones. Thanks again and appreciate your help. I just subscribed to your channel too!

[wenjuanjurewicz]

This is such a life saver - Thank you so much!! This video does exactly what I needed, after my head spins going through so many videos with INDEX MATCH function...

[SimX]

Just what I needed, thank you so much. 365 is so much better.

[mikewchiasson]

Thank you for this. I'm using it to pull together sentences into an initial paragraph to give comments to students on their papers.

[paradigmvisions]

Thanks! This was awesome. Super clear and simple explanation.

[__Est.her__]

I was breaking my head trying to do this with a rather large dataset. Thank you!😭😭😭😭😭😭😭❤

[milansaram]

Exactly what I want, thank you so much

[ashishshiriskar]

Thanks alot . This will very helpful to us. 😁

[butterflyGirly]

Excellent! but I have the data the other way around. Like I have a base table with one record for each row. lookup table has multiple records in cell. How to extract all the records from one cell and display them with a separator in one cell?

[francisguchie]

Exactly what i needed thank you so much

[kugmogamay]

This is great! This gives me an idea to eliminate extra data. For this one though it only says to skip blanks, and ignore the same data, I was wondering if there's an option to skip N/A too (the data is not reflected using vlookup, that's why it's N/A for now)

[intellistruction]

This was Excellent, Thank you!.
How would I use the same function but instead of having the function return the Titles of books read, the Row numbers would be returned

[kevingarala]

Exactly what I needed, but I have MS office 2013, So can you please explain how this is possible in MS office 2013? As it did not have TEXTJOIN function.

[cococa]

I was hoping this would have the answer to my problem. Unfortunately, the data in the cells isn't as much as I have. I have some cells with too much data. Sometimes the textjoin formula works and sometimes the cells remains blank. At first I didn't understand the problem, but then I took out about 1/2 the data in a cell and it worked. Is there a way to get textjoin to accept the extra data?

[jaredthereal]

Wanting to use this but my "Value if true" data is in a row of cells and that returns 0s for blank cells instead of ignoring them. Is there any way to ignore cells that have no data?

[vv]

nice work..was searcing for this for a long....

its working for exact match only..how to modify the same to match partial text also..???
its not working if we use "*"&cellref&"*" in "="...

[helmyherdian]

what type of office do you use sir??i cant find those formulas (text join and unique)