Return Multiple Match Results in Excel

In this video I demonstrate how to lookup and return multiple values concatenated into one cell. This solution is achieved using TEXTJOIN function. 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.