Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/02/xlookup-only-returning-first-value.xlsx

In this Microsoft Excel video tutorial I demonstrate how to get XLOOKUP to return all matches instead of just the first value. The trick here is not to use XLOOKUP but use the FILTER function instead. Matches can either be displayed vertically or horizontally. Matches can also be displayed in a single cell using the TEXTJOIN function.

Table of Contents:

00:00 - Introduction
00:36 - Use the FILTER function not XLOOKUP
01:28 - Display all results in one cell using the TEXTJOIN function
------------------------