Category:

Course Description:

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. Method 2: Uses the relatively new TEXTJOIN formula (available in Excel Office 365, Excel 2019) and requires CSE. Course Length: 14:12 minutes Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.