INDEX() function

Functions Jun 04, 2019

About  INDEX() function

The INDEX() function is a lookup and reference function that returns the value of returned reference basis the supplied row and column of given array. It keeps 3 parameters and they are array, row_num, column_num.

Where to apply :

This function helps in getting value from a table or database based on supplied row and column.

Syntax :

=INDEX(array, row_num, [column_num])

Parameters :

array - A cell or a range reference.

row_num - A number that is used for row number of supplied array.

column_num - [Optional], a number that is used for column number of supplied array.

Remember - row_num and column_num should not be negative number.

Example :

  1. To retrieve piece of information from an array.

=INDEX({"Code", "Name", "Salary"; 1, "Raj", 5000; 2, "Sam", 10000}, 3, 3)   // Returns (10000)

It returns (10000) from below array.

Image 1 - Array

Excel based example:

We have Student Table

Image 2 - Student Table

We have our another table that needs name based on Roll_no.

Image 2 - Table 2

Fomula to retrieve name from Table 1 based on given Roll_No.

Image 3 - INDEX() function

The INDEX() function is well explained in above image.

Hope, it would have added in your Excel function knowledge.

Thank You!

Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be Excel expert, connect us on:

9599408486 / 8929231250

Manoj kumar

Corporate Trainer at ExcelHour. I have devoted over 9 years to various industries for learning multiple data challenges and trained Excel and VBA courses to the corporate along with offline training.

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.