# Excel Function INDEX

## How to use Excel Function INDEX?

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. arrayrow_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”

## Recommended Articles

Hope you learnt this Function,