Play all

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

Description:

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.

INDEX & MATCH Lookup Functions - Beginning to Advanced

ExcelIsFun

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Manipulation #Spreadsheets #INDEX function #MATCH function #Array Formulas

0:00 / 0:00