Dive into an extensive 1-hour 10-minute video tutorial covering 18 examples of INDEX and MATCH lookup functions in Excel, ranging from basic to advanced techniques. Learn how to perform two-way lookups, vertical and horizontal one-way lookups, approximate lookups on descending sorted tables, and lookups for whole rows and columns. Explore creating dynamic ranges for charts, handling multiple table lookups, flipping tables using INDEX and ROWS, selecting random values, and working with complex array formulas. Master essential Excel skills including handling arrays requiring Ctrl + Shift + Enter (CSE) and extracting data using basic lookup tools in complex array formulas. Download the accompanying Excel start file to practice alongside the tutorial and gain hands-on experience with these powerful Excel functions.
Overview
Syllabus
1 MATCH Functions Basics about minute mark
2 INDEX Basics: Two way lookup about minute mark
3 One way lookup vertical lookup Left about minute mark
4 One way lookup horizontal about minute mark
5 One way lookup with lookup column and match column orientated differently about minute mark
6 INDEX & MATCH to do approximate lookup on table sorted Descending about minute mark
7 Lookup whole row about minute mark
8 Lookup whole column about minute mark
9 Lookup Cell Reference about minute mark
10 Create Dynamic Range For Chart about minute mark
11 Lookup from more than one table when tables are on same sheet as formula about minute mark
12 Lookup from more than one table when tables are on a different sheet than the formula: CHOOSE, INDEX, MATCH functions about minute mark
13 INDEX and ROWS to Filp a Table about minute mark
14 Get Amount in Next Bracket about minute mark
15 Select a Random Value about minute mark
16 Lookup first non-blank value about minute mark
17 Handle arrays that require Ctrl + Shift + Enter CSE about minute mark
18 Basic lookup tool used in complex array formulas for extracting data about minute mark, 1 hour 1 minute 10 seconds
Taught by
ExcelIsFun
