599,144 views 143 on YTPak
1,717 55

Published on 28 Mar 2012 | over 6 years ago

Download file: people.highline.edu/mgirvin/ExcelIsFun.htm

This video is a part of VLookup Week: vlookupweek.wordpress.com

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
Customize Your Hybrid Embed Video Player!

6-digit hexadecimal color code without # symbol.


Report video function is under development.


Loading related videos...