Excel INDEX Function - 5 Secret Features - do you know them all?

Chapters:
0:00 How to use the INDEX Function
1:00 1. Row_Num argument quirk
1:32 2. Returning a Range
3:47 3. Return a Whole Column/Row
5:04 4. Operators
7:14 5. Referencing Non-contiguous Ranges

[wayneedmondson]

Hi Mynda.. great summary of the magic of INDEX and by association, other range returning functions like OFFSET, INDIRECT, CHOOSE, SWITCH and XLOOKUP. Also, an understanding of range operators completes the toolkit. After learning some of these lessons, I've been able to add a lot of formula trickery to my worksheets that was not possible before. Thanks for the comprehensive lesson and for sharing your tips and tricks. Thumbs up!!

[kangsungho]

You have actually taught the hidden rules of excel. Thanks million!

[joshuamanampiu]

I was actually looking for a solid explanation on the INDEX function and this is it. Thank you so much.

[illnatured]

Thanks Mynda, this video helped me solve a real life problem at work. Incredibly useful!

[jimfitch]

Count me among those who was unaware of INDEX’s other uses. No longer! Thanks, Mynda

[vladmykoliuk]

You are the best excel teacher in youtube. Thank you a lot

[ilotvin]

Always a pleasure to learn new ways to use INDEX formula! Thanks.

[SndfOmar]

Wow! Truly amazing.
Didn't know that INDEX could be so magical.
👏 👌
Thank you Mynda for the Excel file.😊

[jueroe]

"MyOnline-Lady", even if Corona creates distance, you fill gaps and connect continents, Thank's again ! As ever, clear, structured and understandable.

[tibibara]

Must watch video, definitely! The intersect operator was new to me, I really enjoyed learning the 'Operators' part. Both the video and the practice file are very professional in every way🔝. I really-really love it, when I can find everything in one place/file/lesson and don't have to go through tons of material for info, so Mynda, thank you so much, it's a privilege to learn from one of the BEST!☺

[IvanCortinas_ES]

Very interesting the paragraph 5 with Non-contiguous Ranges. I didn't know the work of this function with 2 different areas. Thank you Mynda!

[abdulhaseeb]

Wow! Never seen Index do stuff like that. Thanks for bringing this to us.

[XMegaJuni]

Love you! Thank you for sharing your experience and knowledge.

[nonoobott]

Wow...I didn't know about the intersect operator (space). This is very helpful. Thank you

[IvanCortinas_ES]

Very fine file Mynda. Thank you for your explanation!!!

[darrylmorgan]

Hi Mynda!I Just Learned Something New About INDEX..Really Great Tutorial Thank You :)

[Hhunted]

This was a bit over my head, but like your videos.

[msoffice]

Like for a video as always, hope your youtube gets bigger and bigger audience - videos are straight to the point, intermediate and higher level and no waffling :) Thanks for sharing!

[ivespocock]

Great video. Very well explained and illustrated examples of the index function. The excel download is nice to save for the time that I really need to use this function - which I probably will soon now that I know its potential...

[anv.]

Thank you very much Mynda. learnt a lot from your lessons.