# Excel INDEX Function

**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.

### Array form

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.

### Reference form

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.

## Excel Formula Training

Learn Excel formulas and functions with concise, clear videos. Master absolute/relative addresses, dates, text, named ranges, and tools for troubleshooting. Each video comes with a practice worksheet and audio transcript. Instant access and complete 100% guarantee. Start today!