Excel Function

OFFSET

Returns reference offset from a starting reference.

OFFSET(reference, rows, cols, [height], [width])

Arguments

reference

Required

Specify a single cell reference.

rows

Required

Enter a numeric value.

cols

Required

Enter a numeric value.

height

Optional

Enter a numeric value.

width

Optional

Enter a numeric value.

Practice Preview

return a value offset from a reference cell. Use OFFSET to Returns reference offset from a starting reference. use 1 for rows, use 2 for cols, use 1 for height, use 1 for width. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=OFFSET(B2, 1, 2, 1, 1)

Practice This Function

Practice in Sequential ModeBack to Function List