Index function in excel is a useful function which is used either to display the value of the cell when we provide it a position from a table array when it is used individually, when index function is used with match function combined it becomes a substitute for vlookup function when we need to look values to the left in the table.

**Syntax**: =INDEX(array, row_num, [column_num])

The INDEX function syntax has the following arguments:

**array**– a range of cells that you want to return a value from.**row_num**– the row number in array from which you want to return a value. If omitted, the column_num is required.**column_num**– the column number in array from which you want to return a value. If omitted, row_num is required.

**Example 1**: Let’s look at some Excel INDEX function examples and explore how to use the INDEX function as a worksheet function in Microsoft Excel:

**1.1 Syntax**: =INDEX(H8:H13,3)

**Result**:

**1.2 Syntax**: =INDEX(H8:I13,**4,2**)

**Result**:

**1.2 Syntax**: =INDEX(H8:K13,**6,4**)

**Result**:

**Example 2**: Let’s look at some Excel INDEX function examples and explore how to use the INDEX function as a worksheet function in Microsoft Excel:

**2.1 Syntax**: =INDEX((H8:K9,H11:K13),1,1,1)

**Result**:

**2.2 Syntax**: =INDEX((H8:K9,H11:K13),1,1,2)

**Result**:

**2.3 Syntax**: =INDEX((H8:K9,H11:K13),2,1,1)

**Result**:

**2.4 Syntax**: =INDEX((H8:K9,H11:K13),2,1,2)

**Result**:

**2.5 Syntax**: =INDEX((H8:K9,H11:K13),3,4,2)

**Result**:

**2.6 Syntax**: =INDEX((H8:K9,H11:K13),3,4,1)

**Result**:

**Note**: The INDEX function returns the value at a given position in a range or array. INDEX is frequently used together with the MATCH function. MATCH locates and feeds a position to INDEX,which returns the value at that position.