How To Use INDEX Function | Microsoft Excel

INDEX Function will return you a specific value from the table.
Index function calculates the given row number and column number from the table and returns the intersection value.

Syntax of INDEX Function

=INDEX(array,row_num,[column_num])

Arguments of INDEX Function

array: range of data or a table

row_num: row number from the table which value you want in return

column_num: column number from the table which intersects the row number and returns value

Behavior of INDEX Function

Here you want to see a price for the month of April.

So you have to select a table and apply the formula.

=INDEX(B4: E9,4,3)

Here

B4: E9 is a table

4 is a row number

3 is a column number

This formula will return you the intersection of row and column from the table

The result is "1100"

Usage of INDEX Function

To get a specific value from the specified row and column object from the selected table

Return of INDEX Function

A specific value where a condition is applied

Notes

If there is one row and one column in the table so row number and column number will be optional

Error Values

Error Commands	Description
#REF	MIstake in Row number or Column number MIstake in syntax
#VALUE	If you use Manual selecting an array you must use CLTR+SHIFT+ENTER for { } bracket otherwise this error appeared

How would you like this content to write us in the comment box!

If you face any difficulty in the content feel free to ask!

Thank You.