Return Multiple Match Results in Excel (2 methods)
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
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:
Method 1: Uses INDEX & AGGREGATE formulas. This doesn't require CSE (control shift enter) and it works on older Excel versions. Beginning: 1:31, End: 10:20
Method 2: Uses the relatively new TEXTJOIN formula (available in Excel Office 365, Excel 2019) and requires CSE. Beginning: 11:40, End: 13:25
Pick the method you find easier to maintain.
🡻 Download the workbook here 🡻
https://www.xelplus.com/return-multiple-match-values-in-excel/
★ Links to related videos: ★
VLOOKUP basics: https://youtu.be/E7gQ-PgYkMc
INDEX MATCH basics: https://youtu.be/F264FpBDX28
Get Unique List: https://youtu.be/7fYlWeMQ6L8
TEXTJOIN: https://youtu.be/TMZEUlFGp1U
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my Excel top 10 tips and formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео Return Multiple Match Results in Excel (2 methods) канала Leila Gharani
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:
Method 1: Uses INDEX & AGGREGATE formulas. This doesn't require CSE (control shift enter) and it works on older Excel versions. Beginning: 1:31, End: 10:20
Method 2: Uses the relatively new TEXTJOIN formula (available in Excel Office 365, Excel 2019) and requires CSE. Beginning: 11:40, End: 13:25
Pick the method you find easier to maintain.
🡻 Download the workbook here 🡻
https://www.xelplus.com/return-multiple-match-values-in-excel/
★ Links to related videos: ★
VLOOKUP basics: https://youtu.be/E7gQ-PgYkMc
INDEX MATCH basics: https://youtu.be/F264FpBDX28
Get Unique List: https://youtu.be/7fYlWeMQ6L8
TEXTJOIN: https://youtu.be/TMZEUlFGp1U
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my Excel top 10 tips and formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео Return Multiple Match Results in Excel (2 methods) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use Excel Index Match (the right way)Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions)10 Excel formatting tricks *ONLY* experts knowVLOOKUP Return Multiple Matching Rows and ColumnsPROPERLY Share Your Screen in a Microsoft Teams Meeting (For BEST Experience!)Excel Dynamic Arrays (How they will change EVERYTHING!)Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1Use VLOOKUP to Find the 2nd Match (or nth Match)INDEX MATCH Explained (An Alternative to VLOOKUP)Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank CellsBuild Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)6 FREE Add-Ins for Excel to Start Using NowMicrosoft Excel Vlookup Function with Multiple CriteriaHow Power Query Will Change the Way You Use ExcelExcel VLOOKUP With Multiple WorkbooksLookup and Find the 2nd, 3rd, or the Nth Matching Value in ExcelConsolidate & Clean Multiple Excel Sheets in One Pivot TableExcel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)Searchable Drop Down List in Excel (Very Easy with FILTER Function)