INDEX formula returns a value in a table based on the intersection of a row and column position within that table.
Syntax for INDEX formula
INDEX(array, row_number, column_number)
Parameters Details:
- array : A range of cells that contains the table of data.
- row_number : The row position in the table where the value you want to lookup is located. This is the relative row position in the table and not the actual row number in the worksheet.
- column_number : The column position in the table where the value you want to lookup is located. This is the relative column position in the table and not the actual column number in the worksheet.
Returns
The INDEX function returns any datatype such as a string, numeric, date, etc.
