The Incredible INDEX Function - Is it Excels Most Useful Function?
Alan Murray, IT Trainer, Coffee Lover and Lifelong learner
7 Lessons (49m)
-
-
1. Introduction
3:59 -
2. Example 1 - Using INDEX and MATCH for an Advanced Lookup
11:09 -
3. Example 2 - Create a Picture Lookup
8:01 -
4. Example 3 - Return the Value from the Last Row
2:51 -
5. Example 4 - Create a Dynamic Named Range
12:10 -
6. Example 5 - Sum the Last 6 Values Only
4:43 -
7. Example 6 - Retrieve a Range from a List of Ranges
5:59
-