Function Type: Lookup and Reference
Description:
INDEX function returns the value of a given location in a table range or array. This function is commonly used with MATCH function which give us the location of the lookup_value.
Function Structure:
=INDEX(array, row_number, [column_number])
Argument Breakdown:
array – This is the group of cells where your excel will look into.
row_number – This is the row location in your array. This argument requires a number input. A function that returns a number such as MATCH can also be used here.
column_number – This is the column location in your array. This argument requires a number input. A function that returns a number such as MATCH can also be used here.
Example:
Say we want to look into the Price of the Tool Box, The formula will be
=INDEX(A2:C8,6,2)
This means that Excel will return the value in the intersection of 6th row and 2nd column of the array A2:C8.
One thought on “INDEX function”