Lookup
Reading which row a cell sits in
Definition
Reading the row number of a cell means giving ROW that cell.
Syntax
=ROW(reference)
Arguments
| Argument | Meaning |
|---|---|
reference |
The cell whose row number you need, such as B6. |
Worked example
A packing list stores a marker in B6. The formula sits in D2 and must report that row.
| A: Item | B: Mark |
|---|---|
| Crate | |
| Box | |
| Bag |
Formula: =ROW(B6)
Result: 6. B6 is on row 6.
Practice
Cell C9 holds x. In D2, write a formula that returns the row number of C9.
- In D2, write a ROW formula for C9.
- D2 should show the row of C9.
Step 1 of 2
Enter =ROW(C9) in D2.
C9 is in row 9.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
D2 uses ROW.
D2 now shows 9.
The next lesson is Reading which column a cell sits in.
Related functions
ROW is the function that returns the row number of that cell.
Common mistake
Leaving the cell out, as in =ROW(): the formula then reports its own row, 2, instead of 6.