INDEX Function in Excel - Complete Guide | 5 Examples

This video is a complete guide to the INDEX function in Excel including five examples.
The Excel INDEX function is possibly the best Excel function. This video starts with a basic Excel INDEX function example. It then moves on to show INDEX ad MATCH in Excel and also INDEX formula to return arrays and ranges.
Learn ALL the best functions in Excel - amzn.to/3Rg87Go
Download the sample workbook to play along - www.computergaga.com/_excel/f...
Rolling chart for the last 6 months - • Create Dynamic Rolling...
Moving average formula with INDEX function in Excel - • Moving Average in Exce...
These are the video timings.
00:00 - Introduction
00:59 - Basic example of the INDEX function in Excel
03:14 - INDEX MATCH in Excel
05:43 - Two-way lookup formula with INDEX MATCH MATCH
08:51 - Get value from the last row
11:11 - Return an array with INDEX in Excel
14:01 - Dynamic name range with the INDEX function
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1

[@tonybarker4240]

Thanks Alan - on the last example - Data Validation Source Box - you can use F3 for the Named Range you created - so that you are certain you have the spelling correct when referring to it. This is also helpful when you have a sheet with many Named Ranges

[@wayneedmondson1065]

Thanks Alan. INDEX is definitely the Swiss army knife of functions. Great examples! Thanks for sharing. Thumbs up!!

[@Computergaga]

Thank you, Wayne

[@samuelkodjoe1645]

for the first time, I now understand the concept of index and match. Thanks for the insight!!

[@Computergaga]

You're welcome. Thank you.

[@balkrishnarana5278]

Most appreciated for this slow sure style of delivering the instructions. Learned a lot of new areas of Excel. Thank you. https.

[@Computergaga]

You are welcome! Thank you for your comments.

[@teoxengineer]

Thank you Alan for this tutorial about Index function.
And one of the most important usages of Indext is dynamic area selection. We can use it with choose, switch and XMatch formulas to extract related area from the list.
And Index():Index() is so powerful function to refer dynamic ranges like Offset and tables as you indicated.

[@Computergaga]

Thank you, Emre. Absolutely, I could have done this video all-day with other examples.
A good mention on the new XMATCH function there.

[@shriram8088]

Thank you Alan.
I was looking for same video.
You have explained everything.

[@Computergaga]

Great! You're welcome.

[@markpodesta4605]

Thank you Alan!

[@Computergaga]

You're welcome, Mark. Thank you.

[@javedahmed8343]

Fantastic explanation.very subtle explanation with simple tables. Thanks

[@Computergaga]

You're welcome, Javed. Thank you.

[@querrythis]

Thanks for sharing your knowledge. Like the last example

[@Computergaga]

Thank you. You're welcome.

[@LongPiset]

Thank you very much brother ❤️

[@Computergaga]

You're welcome 😊

[@premdale]

Love the list tip

[@Computergaga]

Thanks, Gerry.

[@sanjeevkhakre2990]

It's amazing👍. Thank you 🙏

[@Computergaga]

Welcome, Sanjeev 😊

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@Computergaga]

My pleasure. Thank you.

[@silvanodemetrio407]

You are awesome! Great!

[@Computergaga]

Thank you, Silvano 😊

[@jaiprakashswami4021]

Really high quality content

[@Computergaga]

Thank you, Jaiprakash.

[@pranaypradhan8469]

ty sir

[@Computergaga]

No problem.

[@spilledgraphics]

Alan, the last example (17:17) is nice for educational purposes.
Now, in practice, in the trenches of spreadsheet development, referencing an entire column is a capital sin. 😮
Watch out! 🙏😁 either way, cool tutorial mate👌

[@Computergaga]

Thanks, Carlos.

[@stevemansfield8530]

Also worth considering wrapping the Dynamic Range example in the SORT function which will make the list behave alphabetically no matter what letter begins any more countries that get added into the original list.

[@kiedraana5625]

Hi. Didnt work using XL2007 formula is '=SORT($A$2:INDEX($A:$A,COUNTA($A:$A)))
Any help appreciated. Thks

[@chrisk.9765]

Thx for sharing.
Perhaps you know how to create dynamic list (filtering during typing) but from range with more than one column.
The standard list function from ribbon - error checking - doesn't allow to use more than one column.
At the moment I'm using some combination with IF function where I'm checking first few letters and then proper column is selected and list displays content from this column.
Unfortunately this option is imperfect because the idea of dynamic filtering during typing is not fulfilled without additional prefiltering to select specific column.

[@Computergaga]

Thanks, Chris. Sorry, I don't have anything on a multi-column searchable list.

[@florincopaci6821]

Hello! Like usual nice content.to bad that you post so rarely. All the best and a better year!

[@Computergaga]

Thank you, Florin. Your comments are appreciated.

[@florincopaci6821]

@@Computergaga thank you