Look Up Values with INDEX and MATCH functions in Microsoft Excel

  • Post comments:2 Comments



In this lesson, I will show you how to use the INDEX and MATCH functions in Microsoft Excel. You could use INDEX and MATCH instead of VLOOKUP. When used together, this can become a powerful way to look up data in your Excel spreadsheets. In this tutorial, we will start with using the MATCH and INDEX functions independently, then I will show you how to nest the MATCH function inside the INDEX function to make it do more.

Download Practice File: https://bit.ly/index_match_practice

0:00 Introduction
1:09 Create a dropdown list
2:31 How to use the MATCH function in Excel
4:47 How to use the INDEX function in Excel
6:47 How to nest the MATCH function in the INDEX function in Excel

Try out the XLOOKUP function: https://youtu.be/tPaXEZRh9_k
Drop-downs with XLOOIP: https://youtu.be/fjn4vlWwpCo

source

This Post Has 2 Comments

Leave a Reply