Get a value in a list or table based on location

The value at a given location.

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

**array**- A range of cells, or an array constant.**row_num**- The row position in the reference or array.**col_num**- [optional] The column position in the reference or array.**area_num**- [optional] The range in reference that should be used.

Use the INDEX function to get a value from a list or table based on its location. For example, the formula =INDEX(A1:B5,2,2) will return the value at the address B2.

The INDEX function has two forms: array and reference.

In the array form of INDEX, the first parameter is **array**, which is supplied as a range of cells or an array constant. The syntax for the array form of INDEX is:

INDEX (array, row_num, [col_num])

- If both
**row_num**and**col_num**are supplied, INDEX returns the value in the cell at the intersection of**row_num**and**col_num**. - If you
**row_num**is set to zero, INDEX returns an array of values for the entire row. To use these array values, enter the INDEX function as an array formula in horizontal range. - If you
**col_num**is set to zero, INDEX returns an array of values for the entire column. To use these array values, enter the INDEX function as an array formula in vertical range.

In the array form of INDEX, the first parameter is **reference**, which is supplied as a reference to one or more cell ranges. The syntax for the reference form of INDEX is:

INDEX (reference, row_num, [col_num], [area_num])

- The reference form of INDEX returns the reference of the cell at the intersection
**row_num**and**col_num**. - If
**reference**is supplied as multiple ranges,**area_num**indicates which range to use. **area_sum**is supplied as a number. For example, in the formula =INDEX((A1:C5,A7:C10),2,2,2),**area_num**is supplied as 2, which refers to the range A7:C10.