INDEX Function

The INDEX function is used to pick a particular value from a range of data based on the row number and the column number specified. The range of data can be either continuous or separate blocks.

Formula:


Array Form:
=INDEX(array, row num, column num)

whereas "Array" is a range of cells or an array constant.
"Row num" is a row in array. If it is omitted, then column num is required.
"Column num" is a column in array. If it is omitted, then row num is required.
Note: If array contains only one row or column, the corresponding "Row num" or "Col num" is optional.
Reference Form:
=INDEX(reference, row num, column num, area num)

whereas "Reference" is a reference to one or more cell ranges.
"Row num" is a row in the reference.
"Column num" is a column in the reference.
"Area num" indicates which of the multiple areas should be used.The first area is 1, second 2, and so on. If it is omitted, function uses area 1

Video Tutorial:


Let us pick a particular value from a range of data, using the INDEX function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question