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:

Excel INDEX function - How to use the Excel INDEX function

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

Result:

Excel INDEX - How to use the Excel INDEX function

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

Result:

INDEX function - How to use the Excel INDEX function

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

Result:

INDEX function 1 - How to use the Excel INDEX function

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:

Excel INDEX function - How to use the Excel INDEX function

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

Result:

INDEX function 2 - How to use the Excel INDEX function

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

Result:

Excel INDEX function 1 - How to use the Excel INDEX function

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

Result:

Excel INDEX function 2 - How to use the Excel INDEX function

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

Result:

Excel INDEX function 3 - How to use the Excel INDEX function

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

Result:

Excel INDEX function 4 - How to use the Excel INDEX function

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

Result:

Excel INDEX function 5 - How to use the Excel INDEX function

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.

One Comment

  1. Hassan Zia Malik June 10, 2020 Reply

Add a Comment

Your email address will not be published. Required fields are marked *