Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/02/Excel-lookup-return-multiple-values-in-one-cell.xlsx

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