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.

## No comments:

## Post a Comment