Skip to content
# EXCEL FUNCTION – INDEX

# Excel Function INDEX

## How to use Excel Function INDEX?

**Syntax:**

**Syntax Description:**

#### Example 1: INDEX function with Single column in Database

### Example 2: INDEX function with Multiple columns in Database

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

**Things to Remember:**

## Recommended Articles

## Similar Posts

### EXCEL FUNCTION – SUMIFS

### EXCEL FUNCTION – MAX

### EXCEL FUNCTION – AND, OR, NOT

### EXCEL FUNCTION – FIND

### EXCEL FUNCTION – TODAY

### EXCEL FUNCTION – NOW

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

=INDEX(array,row_num,[column_num])

**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

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:

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:

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:

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

SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments

MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1

AND, OR, NOT Functions” provide result in “TRUE” or “FALSE”. If the logical condition is correct and matching the parameters provided, then result would be “TRUE” or if logical condition is not correct and not matching the parameters provided then result would be “FALSE”

FIND function is used to find the position of text, or character in an available string.

Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.

Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.