The Excel INDEX function is a treasure trove of functionality, but most of us only know one way to use it. In this video I want to expose some lesser known quirks and ways it can be used.

Chapters:
0:00​ INDEX Function Syntax
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

Subscribe: https://www.youtube.com/channel/UCiYjpuUaSfkvdZkmtDU7JRw

#excel