How to use the Excel INDEX function

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.