Excel Function: INDEX

The Excel function INDEX searches for a value in an array based on its coordinates.


=INDEX(array, row_no, col_no)

Example of use

The goal here is to display a value from the table based on the row and column numbers:

excel function index

Select the INDEX function and enter:

index function

The function then displays the value according to its position in the table:

index function
If needed, you can download the Excel file used here: index.xlsx
By combining the INDEX function with the MATCH function, it is possible to display the desired result directly based on a value from the table: INDEX + MATCH