
The function will return the cell reference comes at the intersection between row_num and col_num.The syntax of the reference index formula is The reference is supplied to different cell ranges. In this form, the first parameter that comes in syntax is the reference. If col_num is 0, then the Index function will return the values of the entire column.If row_num is 0, then this function will return values for the entire row.If you have row_num and col_num then this formula will return the value present in the cell at its intersection.In Index Array form, the first thing that comes in the formula is an array. Row_num is the position of the row in an array.Ĭol_num is the position of the column in the reference or an array.Īrea_num is the range in reference that you should use. =Index(array, row_num,, )Īrray is the range of cells or constant of an array. The function will return the value present at the given position in the array. The excel Index function is used with match function where the Match function is used to find the position of the value and Index function returns the value of the item at that position.

You need to use the index function to retrieve the values or complete rows and columns. The function will give you the value of an item located at a certain position in an array. Hence if you want to extract any value from an array then you need to use this index match function excel. The Match function in excel returns the position of an item in array whereas the Index function in Excel returns the value present in that position in the array.

In our previous post, we have already cover Excel Match function.
