INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)

Download file: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT778.xlsx

There are really about 30 example in this long video.

Excel INDEX and MATCH functions How To:

1 MATCH Functions Basics (about 0:46 minute mark)
2 INDEX Basics: Two way lookup (about 9:05 minute mark)
3 One way lookup vertical (lookup Left) (about 13:07 minute mark)
4 One way lookup horizontal (about 14:50 minute mark)
5 One way lookup with lookup column and match column orientated differently (about 17:51 minute mark)
6 INDEX & MATCH to do approximate lookup on table sorted Descending (about 19:15 minute mark)
7 Lookup whole row (about 21:41 minute mark)
8 Lookup whole column (about 24:49 minute mark)
9 Lookup Cell Reference (about 26:00 minute mark)
10 Create Dynamic Range For Chart (about 26:00 minute mark)
11 Lookup from more than one table when tables are on same sheet as formula (about 36:29 minute mark)
12 Lookup from more than one table when tables are on a different sheet than the formula: CHOOSE, INDEX, MATCH functions (about 43:31 minute mark)
13 INDEX and ROWS to Filp a Table (about 47:20 minute mark)
14 Get Amount in Next Bracket (about 50:34 minute mark)
15 Select a Random Value (about 53:18 minute mark)
16 Lookup first non-blank value (about 54:24 minute mark)
17 Handle arrays that require Ctrl + Shift + Enter CSE (about 54:24 minute mark)
18 Basic lookup tool used in complex array formulas for extracting data (about 59:59 minute mark, 1 hour 1 minute 10 seconds)

VLOOKUP Shark Week

Buy excelisfun products:
https://teespring.com/stores/excelisfun-store

Видео INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3) канала ExcelIsFun