All Collections
Google Sheets & Excel Formulas
How To Create Dynamic Dashboards with Index/Match
How To Create Dynamic Dashboards with Index/Match

Creating dynamic dashboards using the index match formulas

Lasse Kalkar avatar
Written by Lasse Kalkar
Updated over a week ago

Want to learn Index Match with multiple criteria? You've come to the right place!

Here is a step-by-step guide on how to do an Index Match with multiple criteria (also called Index Match Match).

The fastest way to get started is to watch our detailed video below, which explains how the index match formula works and how you can use it to build a real-time and dynamic financial dashboard in Google Sheets & Excel.

The video is broken down into 4 sections:

  1. How to do a basic Index Match function

  2. How to do Index Match with multiple criteria

  3. How to do Index Match with multiple criteria to create a live P&L dashboard in Google Sheets

  4. How to do Index Match with multiple criteria to create a live Consolidated P&L dashboard in Google Sheets
    ​

The video is around 14 minutes long, and yes, it feels like a long time, but we promise you! It's worth it. Mastering this formula will take your skills to the next level and save you countless hours down the road! If you're in a rush, you can always break it down into multiple stages and watch the first part, but we highly recommend watching the whole video to the end.

We don't want you to miss out on the key concepts.

Enjoy!

‍

Learn how to do this step-by-step in the video below πŸ‘‡

Did this answer your question?