Completed
Excel 3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Lookup Formulas
Automatically move to the next video in the Classroom when playback concludes
- 1 Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
- 2 How to use Excel Index Match (the right way)
- 3 Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)
- 4 Excel 3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX
- 5 Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs
- 6 Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header
- 7 Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT
- 8 Excel Formula Lookup Multiple Results: Return headers based on matrix values
- 9 TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin
- 10 Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel
- 11 Return Multiple Match Results in Excel (2 methods)
- 12 VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples
- 13 Excel RANK without Skipping Numbers (Top 3 Report with Duplicates)
- 14 LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)
- 15 Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)
- 16 Left Lookup in Excel with XLOOKUP (Made Easy)
- 17 How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)
- 18 Excel DGET Function Solves 2 of Your VLOOKUP Problems
- 19 Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions)