All the basic information regarding INDEX function in Excel is listed in the table below. (This data is regularly updated from Microsoft and several resources)
|Function Category:||Lookup and reference|
|Description:||Uses an index to choose a value from a reference or array|
|Return Value:||The value at a given location.|
|Syntax:||=INDEX (array, row_num, [col_num], [area_num])|
|Applies to:||Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000|
|Other languages:||English: INDEX
|Portuguese (Brazil): ÍNDICE
Portuguese (Portugal): ÍNDICE
All Other Languages: INDEX
|Related Functions:||MATCH, VLOOKUP|
Syntax details with an example regarding the correct usage of function can be seen below.
=INDEX (array, row_num, [col_num], [area_num])
|array||A range of cells, or an array constant.|
|row_num||The row position in the reference or array.|
|col_num [optional]||The column position in the reference or array.|
|area_num [optional]||The range in reference that should be used.|
Check the video below to see How to use Excel INDEX function with some examples:
LINKS AND RESOURCES
Here we provide a list of useful links which we think can be useful while trying to learn the function usage with some examples and tips.
Microsoft Office support page – Excel INDEX function:
INDEX & MATCH functions in Excel – a better alternative to VLOOKUP:
EXCEL FORMULAS TRAINER
As said: Practice Makes Perfect!
Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.
30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now: