When a cell reference is provided, ROW returns the row number of the cell.
When a range is provided, ROW returns the first row number in the range.
For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.
When no reference is provided, ROW returns the row number of the cell which contains the formula.
you’ve got the option to use INDEX to retrieve individual values, or entire rows and columns.
