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
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