XLOOKUP Only Returns First Value | XLOOKUP Return all Matches Vertically Or All Matches in One Cell

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

[jannakregoski]

Exactly what I needed - clear, simple. Made my spreadsheet work much faster. Thank you!

[IvanCortinas_ES]

Excellent explanation. Clear, direct, precise, necessary for the daily use of the tool. Congratulations Chester.

[polloslasmargaritas]

Awesome video, works great!!.You can even add a UNIQUE function so that it doesn´t show any repeated elements. Thanks a lot!

[cz]

Great video. how about if you want to sum those values? and if there is another logical test

[peterhughes]

what about if you wanted to add all of Barbara's scores together?

[shoaibrehman]

Excellent video. Is there any possibility we can say top 3 or bottom 3 value will display? By using formula large and small i haven't try yet.

[fernandodiaz]

This is great but what if you dont want to use data validation and instead want to make a new list where the value "Bill" is repeated and you want each entry to have its corresponding value. I was successful in making the name list with repeating entries but the numbers only match the first value and not the exact vlaue for each entry. Please help.

[GuruAnterKhalsa]

How would we sum all of these values into a single value?

[AzamKhan-pqvq]

Dear Respected Sir,
How to see total score sir

[FA-dzls]

If I use index match and it returns first value, how to make it return second value not first