Return Multiple Match Results in Excel (2 methods)
🔥 400,000+ professionals trust our courses—start your journey here 👉 https://link.xelplus.com/yt-d-all-cou...
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:
⬇️ Download the workbook here: https://pages.xelplus.com/multiple-ma...
In this video, you'll discover:
▪️ Method 1: INDEX & AGGREGATE: Dive into a more complex approach that works on all Excel versions without requiring CSE (Control + Shift + Enter).
▪️ Method 2: TEXTJOIN Function: Explore a simpler, more straightforward method ideal for users with Excel 2016 and Office 365. This method utilizes CSE for optimal results.
▪️ Practical Examples: Learn through real-world scenarios, making it easier to apply these techniques to your own Excel projects.
▪️ Dynamic Data Sets: Understand how to work with various data sets, enhancing your flexibility and adaptability in Excel.
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 Matches in Excel
13:36 Wrap Up
★ Links to related videos: ★
VLOOKUP basics: • Excel VLOOKUP: Basics of VLOOKUP and ...
INDEX MATCH basics: • How to use Excel Index Match (the rig...
Get Unique List: • Extract UNIQUE Items for Dynamic Data...
TEXTJOIN: • How to Solve Complex Lookup Problems ...
➡️ Join this channel to get access to perks: / @leilagharani
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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!
#excel
Watch video Return Multiple Match Results in Excel (2 methods) online without registration, duration hours minute second in high quality. This video was added by user Leila Gharani 30 August 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,978,353 once and liked it 23 thousand people.