Excel Index Function - Download Practice Sheet

Excel Index Function:-

The feature of "Index" function: –

• With the help of Index Function, we can retrieve the value of the cell in the selected array by providing the position of the cell.
• It helps in getting a particular value of the certain position of the cell in the selected array.
• We can provide position dynamically by the match function.

Explanation of Function:-

=INDEX(array, row_num, [col_num], [area_num])

Example of Function: –