Today we will learn about Index Function in Excel. Index Function in Excel is one of the most useful function. When we combine this function with another function like Match etc, it will produce the dynamic result.The INDEX function returns a value or the reference to a value from within a table or range.

In the below image we can see the Index function has two different formula like :-

1. ** Index (Array, Row_num,[Col_num]**

2. **Index (Reference, Row_num,[col_num],[area_num]**

In the first formula it is **Array** and in the second function in place array it is **Reference.**

**
**We will give separate example for both of the format.

## Array form

We can see that some values are in the bracket like **[column_num**] and in second function **[column_num]** and **[area_num]**. i.e. if these values does not exist then we will consider these values as “0” and the function will produce the result by without these values.

Image 1 |

**Example 1.**

Image 2 |

**Example 2.**

Image 3 |

**Example 3.**

Image 4 |

In this example if we change the “row_num” and “col_num” according to need then we do not need to change the formula, it will produce the result automatically, “**Just try it”** because in this example “row_num” and “col_num” are cell reference. So we can change the value.

## Reference form

**reference**, which is supplied as a reference to one or more cell range. The syntax of

**reference**is :

Image 5 |

**=INDEX((A2:C5,A7:C10),2,2,1)**

**“A2:C5”**and “

**A7:C10″**then come to “row_num” (2) and column_num(2) the and the last section is “area_num”

**“A2:C5”)**or area_num =2 (“

**A7:C10″)**

**area_num**the result would be

**“Vaucheron & Constantin 18K”**but if we put “1” in the

**area_num**then result would be different i. e.

**“Cartier Tank 18K”**