How to use “INDEX” function in Excel

INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.

INDEX function has two Required arguments i.e. array, row_num and one Optional argument i.e. [column_num]. [column_num] argument is optional only if array argument contains one column.

Syntax:

=INDEX(array,row_num,[column_num])

Syntax Description:

array argument is used to give the cell range from which you want to get value

row_num argument is used to give the row number from which value is required

[column_num] argument is used to give the column number from which value is required. If array argument only has only one column, then [column_num] argument is optional

Example 1: INDEX function with Single column in Database

Here we have one example, where:

• “Column A” has details of products
• “Column B” shows the sample formula applied
• “Column C” shows the output of the function and,
• Explanation is provided in Column “D”. We will be using INDEX function as follows:

Example 2: INDEX function with Multiple columns in Database

Here we have another example, where:

• “Column A to Column C” contains details of products,
• “Column D” shows the sample formula applied,
• “Column E” shows the output of the function and,
• Explanation is provided in Column “F”, we will be applying  function as follows:

Example 3: INDEX function with Multiple Arrays and Areas in Database:

Here we have another example, where:

• “Column A to Column C” contains details of products,
• “Column D” shows the sample formula applied,
• “Column E” shows the output of the function and,
• Explanation is provided in Column “F”, we will be using function as follows:

Things to Remember:

– If cell reference is not correctly provided in the function, then it may give output as Error.

– If output of the function is not as per the desired format then you may change the cell format to “GENERAL”

Hope you learnt this Function,

Don’t forget to leave your valuable comments!

If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons: