Excel Function

ROW

Returns row number of a reference.

ROW([reference])

Arguments

reference

Optional

Specify a single cell reference.

Practice Preview

return values matched by lookup keys. Use ROW to Returns row number of a reference. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=ROW(B2)

Practice This Function