articles

Home / DeveloperSection / Articles / INDEX function in Excel

INDEX function in Excel

AVADHESH PATEL3735 27-Mar-2013

Index function returns a value or the reference to a value from within a table or range. There are two forms of the INDEX function: the array form and the reference form.

Array form

-          Return the value of a specified cell or array of cells

Reference form

-          Return a reference to specified cells

Array form
Syntax

INDEX(array,row_num,column_num) 

Array - is a range of cells or an array constant. 

-          If array contains only one row or column, the corresponding row_num or column_num argument is optional.

-          If array has more than one row and more than one column, and only row_num or column_num is used, INDEX returns an array of the entire row or column in array. 

Row_num - selects the row in array from which to return a value. If row_num is omitted, column_num is required. 

Column_num - selects the column in array from which to return a value. If column_num is omitted, row_num is required.         

INDEX function in Excel

Reference form
Syntax

INDEX(reference,row_num,column_num,area_num) 

Reference - is a reference to one or more cell ranges. 

-          If you are entering a nonadjacent range for the reference, enclose reference in parentheses.

-          If each area in reference contains only one row or column, the row_num or column_num argument, respectively, is optional. For example, for a single row reference, use INDEX(reference,,column_num). 

Row_num - is the number of the row in reference from which to return a reference. 

Column_num - is the number of the column in reference from which to return a reference. 

Area_num  - selects a range in reference from which to return the intersection of row_num and column_num. The first area selected or entered is numbered 1, the second is 2, and so on. If area_num is omitted, INDEX uses area 1. 

INDEX function in Excel


Updated 07-Sep-2019
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By