Index Formula in MS Excel

 Index Formula in MS Excel

The INDEX function in Microsoft Excel returns the value of a cell in a specified table or range, based on the row and column number you specify.

The syntax for the INDEX function is:

=INDEX(array, row_num, [column_num])

where:

array = the range or table of cells you want to retrieve data from 

row_num = the number of the row in the range or table from which you want to retrieve data

column_num = (optional) the number of the column in the range or table from which you want to retrieve data

Here's an example of using the INDEX function:

=INDEX(A1:C5, 3, 2)

This will return the value in the cell at the intersection of the 3rd row and 2nd column in the range A1:C5. If column_num is omitted, it defaults to 1, meaning the INDEX function will retrieve the value from the first column in the specified row.

Note: The row and column numbers start at 1, not 0.