INDEX() returns the value of a cell in a table based on the column and row number.
The INDEX function in Excel is fantastically flexible and powerful, and you'll find it in a huge number of Excel formulas, especially advanced formulas.
Syntax
INDEX(array, row_num, [column_num])
Arguments
1. array - a range of cells that you want to return a value from.
2. row_num - the row number in array from which you want to return a value.
3. column_num - the column number in array from which you want to return a value.
Explain
Example 1
