Return Multiple Match Results in Excel (2 methods)




About this tutorial:

Video duration: 00:14:13
★ Check the Excel Essentials Course:

Quickly learn how to lookup one value in Excel and return multiple matches.
VLOOKUP and INDEX & MATCH formulas always return the first match they find inside a data table. What if you wanted to return multiple matches? I’ll show you two different methods:

★ Get the Official XelPlus MERCH:

Timestamps
00:00 How to Find Multiple Match Results in Excel
01:10 How to Use INDEX & AGGREGATE to Find Multiple Matches in Excel
11:12 How to Use TEXTJOIN to Find Multiple…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads