INDEX formula returns a value from a table based on the specified row and column number.
INDEX formula is often used along with MATCH to lookup values from a data set
Read more about INDEX function here:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
What a great explantion about index function of excel , I learn 't a lot's from , Thanks a tonne.
Well done-thank you!
Your voice is very irritating
Hi Sumit.. what an excellent tutorial. Thanks for sharing your wisdom and knowledge about INDEX and MATCH, as well as the cool examples of putting them to work. Watching your videos and learning your examples makes me better at what I do in my work. Thanks and thumbs up!
what a knowldge! i am working with excel last 10 years but know it first time. God bless you
Really nice video 👍 👍
Excellent, one of the best explanations I have seen for the INDEX function – especially the use of the references in the second example in the table. Good work, thanks for taking the time to share.
It is very clear explanation. Thank you so much !
This video is helpful to me
Fantastic function
SUM function can also works in the similar way. I am unable to understand why have you used index under SUM then?
for me if we give 0 as column number it was giving value error