The Incredible INDEX Function - Is it Excels Most Useful Function?

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
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

Project Description

Open the index-project.xlsx file.

  1. Write an INDEX-MATCH formula in cell C3 of the Lookup sheet. This formula will return the Member name from the Members sheet for the ID entered in cell B3.
  2. Copy the formula across to cells D3 and E3 to return the Country and Membership for that same member.
  3. Create a dynamic named range for the list of countries on the Countries sheet.

Resources(1)

Student Projects