Articles → EXCEL FORMULA → Index Function In Excel
Index Function In Excel
What Is An Index?
Click to Enlarge
- Second item in the sweet dish section
- See the item in the second row and second column of the menu.
Purpose Of Index Function
Syntax
=Index(array, row_number, col_number)
- Array – collection of objects.
- Row_number – As the name suggests, this parameter represents row number in the collection.
- col_number – As the name suggests, this parameter represents column number in the collection.
Example
Click to Enlarge
Click to Enlarge
Click to Enlarge