[PDF]Index Function In Excel

Imparting knowledge


%


Gyan Sangrah


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)

Beverages Sweet Dish


Tea... .

.20

Chocolate.

. 15

Coffee.

.30

Ice cream .

. 50


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

1. Second item in the sweet dish section

2. 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


1. Array - collection of objects.







2. Row_number - As the name suggests, this parameter represents row number in the
collection.

3. col_number - As the name suggests, this parameter represents column number in the
collection.

Example



A

B

C

1

Name

Class


2

Am it

1


3

Sumit

II


4

Vishal

III

Am it

5

Sandeep

IV


6

Anurag

V


7

Ritesh

VI






A A

B

C

1

Name

Class


2 ,

Am it |i

1


3 :

5umit 1

II


4 '

Vishal 1

III

5umit

5 _!

5andeep 1

IV


6 ,

Anurag '

V


7 _l

Ritesh '

VI




A

B

C D

1

Name

Class


2

Amit



3

Sumit

II


4

Vishal

111

|=INDEX(A2:A 7f i)|

5

Sandeep

IV


6

Anurag

V


-

Ritesh

VI






A

B

C D

1

Name

Class


2

Amit

1


3

Sumit

II


4

Vishal

III

=INDEX(A2:B 7 ,2 ( i)|

5

Sandeep

IV


6

Anurag

V


7

Ritesh

VI


A





A

B

C D ,

1

Name

Class

2

Amit

1


3

Sumit

II


4

Vishal

III

=INDEX(A2:B 7< 2,2|)

5

Sandeep

IV

INDEX(array, row_num,

6

Anurag

V_

INDEX(reference, rowj

7

Ritesh

V!




A

B

1 c 1

1

Name

Class


2

Amit 1


3

Sumit

II


4

Vishal

III

II

5

Sandeep

IV


6

Anurag

V


7

Ritesh

VI