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

Download the featured file here: https://www.bluepecantraining.com/wp-...

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.
------------------------