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

• #howto_style
• #excel_lookup_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_return_multiple_values_in_one_cell_separated_by_comma
• #how_do_you_combine_values_in_a_column_in_a_row_separated_by_comma
• #lookup_and_return_multiple_values_concatenated_into_one_cell
• #lookup_and_return_multiple_values_in_excel
• #lookup_and_return_multiple_values
• #vlookup_and_return_multiple_values