INDEX function

---

---

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.

---

---