How to use the INDEX function in Excel [step by step]
Tell INDEX which row and column to look at and it will tell you what's in that exact cell.
INDEX is mostly known for its great use in combination with the MATCH function but it has stand-alone uses.
🕒 TIMESTAMPS
0:00 How to use INDEX
0:42 Input the array (range)
1:11 Which row/column to return value from
1:59 Make it dynamic
👍 LIKE AND SUBSCRIBE
If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment!
🎁FREE COURSES
Try my free 30-minute Excel course and join 100,000+ students: https://spreadsheeto.com
Learn Power BI for free and create impactful reports in just 30 minutes: https://spreadsheeto.com/free-power-b...
🏆PAID COURSES
Zero to Hero. From beginner to Excel expert in 14 hours: https://spreadsheeto.com/zero-to-hero/
VBA Masterclass. Become a VBA pro in 20 hours: https://spreadsheeto.com/vba-mastercl...
Power BI Essentials. Master Power BI in 12 hours: https://spreadsheeto.com/power-bi/
🧑💻HIRE ME AND MY TEAM
We develop custom Excel systems: https://spreadsheeto.com/excel-consul...