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.