The Excel INDEX function returns the value at a given position in a range.

INDEX function is often used with the MATCH function.

INDEX (range, row_num, col_num)

range - A range of cells.

row_num - The row position in the range of cells.

col_num - The column position in the range.

In the example, the INDEX function is used to fetch the values of row 1 of the table and column no. 1

Similarly the other row and column values can be fetched by changing the row and column numbers.

NOTE: The range is taken as absolute reference by putting "$" sign in the range as "$A$62:$C$72" as we are refering the same range again and again.

So now you know how to use INDEX function in MS EXCELLENT. If you have any questions, feel free to contact at dataentryikc@gmail.com