# How to use Excel INDEX function

## SUMMARY INFO

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: INDEX 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 French: INDEX German: INDEX Spanish: INDICE Dutch: INDEX Italian: INDICE Russian: ИНДЕКС Danish: INDEKS Swedish: INDEX Portuguese (Brazil): ÍNDICE Polish: INDEKS Finnish: INDEKSI Norwegian: INDEKS Portuguese (Portugal): ÍNDICE Czech: INDEX Hungarian: INDEX Turkish: İNDİS All Other Languages: INDEX Related Functions: MATCH, VLOOKUP

## FUNCTION DETAILS

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.

## VIDEO EXAMPLES

Check the video below to see How to use Excel INDEX function with some examples:

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:
https://support.office.com/en-us/article/INDEX-function-a5dcf0dd-996d-40a4-a822-b56b061328bd

INDEX & MATCH functions in Excel – a better alternative to VLOOKUP: