How to use the Match and Index excel functions | Match and index explained
In this video you'll learn about the INDEX and MATCH functions in excel. Stand alone the INDEX and MATCH really don't do much, yet when you combine (or nest) either of these functions with other excel functionality, real magic can happen.
We'll start off by learning the INDEX function, then move on to the MATCH function, from there finish the tutorial by looking at a practical example.
⌚ ** TIMESTAMPS **
0:00 Intro
0:25 INDEX function made easy
1:53 MATCH function made easy
4:31 Using MATCH and INDEX for two way look-ups
5:45 Practical example combining the MATCH and INDEX
💾 ** DOWNLOAD PRACTICE FILE **
https://1drv.ms/x/s!AgnhzVKiTqWmgQ5vY...
📄 *RESOURCES*
Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...
Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...
☕ ** BUY ME A COFFEE? **
https://www.buymeacoffee.com/professo...
Смотрите видео How to use the Match and Index excel functions | Match and index explained онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Professor Cubs 22 Август 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 417 раз и оно понравилось 15 людям.