INDEX

The INDEX formula is used to return a value from a specified cell within a range of cells. To use the INDEX formula, select the cell where you want the result to appear and enter “=INDEX(” followed by the range of cells you want to search in and the row and column numbers of the cell you want to return. For example, “=INDEX(A1:D5,3,2)” would return the value in the third row and second column of cells A1 through D5.

Example:

Return the value in the third row and second column of cells A1 through D5: =INDEX(A1:D5,3,2).