Login
Excel Yourself/INDEX and MATCH Solutions (1.5 hrs)
Buy now

  • $25

INDEX and MATCH Solutions (1.5 hrs)


An Index or a Contents sheet are required for Excel files that have multiple tabs.

The techniques covered in this session can also be applied to Instruction sheets and other sheets to improve the general navigation around your Excel files.

Six techniques are covered
  • Manual hyperlinks
  • Using cell links to navigate
  • Applying the HYPERLINK function
  • Using range names (including an unbreakable hyperlink)
  • Macros
  • Using an old Excel macro plus new dynamic arrays
As always lots of shortcuts will be shared along the way.
Buy now

Contents

INDEX and MATCH Solutions

The INDEX-MATCH combination is an advanced technique that can solve many look up problems. The two functions are useful in their own right, but together they provide a range of solutions to common look up requirements.

In this session you will
  • learn the basics of the INDEX function
  • see how versatile INDEX can be in solving problems
  • learn the basics of the MATCH function
  • discover how well they work together to solve look up problems
  • find out how they work with formatted tables
  • see how to handle errors
  • learn how well INDEX works with dynamic arrays
As always, you will discover a few other tips during the session.
INDEX and MATCH Solutions

    Course materials

     The session materials
    • a pdf manual which you can print out and make notes in
    • Excel file to work through during the session
    • the completed file to review if you need to
    Excel INDEX-MATCH Solutions.pdf
    • 645 KB
    INDEX and MATCH Solutions.xlsx
    • 157 KB
    INDEX and MATCH Solutions completed.xlsx
    • 164 KB

    Course Video

    INDEX MATCH Solutions video recording
    • (1h 31m 08s)
    • 326 MB

    Course Quiz

    Test out your new found knowledge with 10 multiple choice questions.
    INDEX and MATCH Solutions Quiz