INDEX MATCH Excel Tutorial
In this step-by-step tutorial, learn how to use Index Match in Microsoft Excel to lookup values. We start with how to use the index function. We use the game Battleship as an example to make it easy to understand. The index function returns a value or the reference to a value from within a table or range. Next, we look at how to use the match function. The match function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. We then bring both index and match together to find specific values within an array. We start with a simple example and then we finish with two more advanced examples. We also look at how to set up a simple drop down list to start building an interactive dashboard.
👋 Additional resources
- Sample workbook to follow-along: https://1drv.ms/x/s!AmxrofZZlZ-whMguWNsN6AkHM4pGkw?e=O3CjoS
⌚ Timestamps
0:00 Introduction
1:16 Index function
3:31 Match function
5:36 Index & match simple example
8:50 Index & match advanced example 1
11:54 Drop down lists with index match
13:01 Index & match advanced example 2
15:02 Wrap up
📃 Watch related playlists
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Видео INDEX MATCH Excel Tutorial канала Kevin Stratvert
👋 Additional resources
- Sample workbook to follow-along: https://1drv.ms/x/s!AmxrofZZlZ-whMguWNsN6AkHM4pGkw?e=O3CjoS
⌚ Timestamps
0:00 Introduction
1:16 Index function
3:31 Match function
5:36 Index & match simple example
8:50 Index & match advanced example 1
11:54 Drop down lists with index match
13:01 Index & match advanced example 2
15:02 Wrap up
📃 Watch related playlists
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Видео INDEX MATCH Excel Tutorial канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use VLOOKUP in Excel - Complete Tutorial6 Incredible Excel INDEX/MATCH Lookup Examples - Workbook IncludedHow to use Power Pivot in ExcelHow to Create Modern Excel Data Entry Form - EASY & NO VBAHow to use Excel Index Match (the right way)Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)📊 How to Build Excel Interactive DashboardsINDEX MATCH Explained (An Alternative to VLOOKUP)How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)How to Create Dependent Drop-Down List in Excel5 Excel Functions YOU NEED in 2021Index Match with Multiple CriteriaLookup values across multiple worksheets: VLOOKUP / INDEX MATCH in ExcelExcel for Accounting - 10 Excel Functions You NEED to KNOW!Return Multiple Match Results in Excel (2 methods)Excel Solver & Goal Seek TutorialHow to use Microsoft Power QueryTop 20 Microsoft Excel Tips & TricksPivot Table Excel Tutorial