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

Use OFFSET to return the result with these settings (Reference: B2 (cell B2 (Product Name in column B)), Rows: 1, Column offset: 2, Height: 1, Width: 1).

Example Table

#	AProduct ID	BProduct Name	CPrice	DStock
2	P001	Apple	120	80
3	P002	Banana	98	120
4	P003	Notebook	450	35
5	P004	Pen	300	60
6	P005	Grapes	150	45
7	P006	Ruler	250	20
8	P007	Peach	86	55

How to Use (Formula)

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

Result

120

Practice This Function

Start Function Practice Back to Function List

OFFSET FAQ

How do I use OFFSET in Excel?

Use OFFSET when you want to reference a range offset from a starting cell. Enter Reference, Rows, Column offset in that order, then add optional arguments when needed.

Where can I practice OFFSET?

Use the "Start Function Practice" button to jump straight into OFFSET drills.

What arguments does OFFSET use?

The main arguments are Reference, Rows, Column offset, Height, Width. Start with the required ones, then add optional arguments if needed.