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.

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;

*** Online Excel Courses ***

Connect with us!

[wayneedmondson]

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

[tonybarker]

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

[samuelkodjoe]

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

[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.

[balkrishnarana]

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

[shriram]

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

[javedahmed]

Fantastic explanation.very subtle explanation with simple tables. Thanks

[querrythis]

Thanks for sharing your knowledge. Like the last example

[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👌

[stevemansfield]

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.

[florincopaci]

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

[chrisk.]

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.