Articles → EXCEL FORMULA → Index Function In Excel

Index Function In Excel

In this article, we will discuss index function in excel.

What Is An Index?

To explain the index, let us consider an example of a restaurant menu (see the figure below)

Picture showing the index of a restaurant menu

Click to Enlarge

If you are browsing the menu and you ask waiter – where is the ice cream in the menu. The reply could be

Second item in the sweet dish section
See the item in the second row and second column of the menu.

In both the cases, ‘second item’ or ‘second row and second column’ is the index. So index is a number that defines the position of the object in a collection.

Purpose Of Index Function

Index function returns the object from a specific position in a collection.

Syntax

=Index(array, row_number, col_number)

In the above syntax

Array – collection of objects.
Row_number – As the name suggests, this parameter represents row number in the collection.
col_number – As the name suggests, this parameter represents column number in the collection.

Example

Picture showing the output of Index function in excel

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Saturday, January 7, 2017

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**