This post will guide you how to use Excel INDEX function with syntax and examples in Microsoft excel.
The Excel INDEX function returns a value from a table based on the index (row number and column number)
The INDEX function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function.
The INDEX function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.
The syntax of the INDEX function is as below:
= INDEX (array, row_num,[column_num])
Where the INDEX function arguments are:
array -This is a required argument. A range of cells or data array.
Row_num – The row number in data array
Column_num – The column position in data array.
Note: If you set the row_num and column_num at the same time, the INDEX function will return the value in the cell at the intersection of row number and column number.
If you set the value of row_num or column_num to 0, the INDEX function will return the array of values for the entire row or column in the array data.
The below examples will show you how to use Excel INDEX Lookup and Reference Function to return a value from a table based on the intersection of row number and column number.
#1 To get the value at the intersection of the second row and second column in the table array: A1:C2, just using the following excel formula: =INDEX(A1:C2,2,2)