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

### Examples

The formulas below show how INDEX can be used to get a value:

In the examples above, the location is "hardcoded". Typically, the MATCH function is used to find the location, which is then fed into INDEX. This article explains how INDEX and MATCH can be used together with many examples:

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
**row_num**is set to zero, INDEX returns an array of values for an entire column. To use these array values, you can enter the INDEX function as an array formula in horizontal range, or feed the array into another function. - If
**col_num**is set to zero, INDEX returns an array of values for an entire row. To use these array values, you can enter the INDEX function as an array formula in vertical range, or feed the array into another function.

### Reference form

In the reference 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_num**is supplied as a number. For example, in the formula below,**area_num**is supplied as 2, which refers to the range A7:C10.

=INDEX((A1:C5,A7:C10),2,2,2)

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.