Subscriber only lesson.
Sign up to this course to view this lesson.
Discover how to use OFFSET function in a formula.
When to use
In its most basic form, OFFSET(Ref,x,y) will select a reference x rows down (-x would be x rows up) and y rows to the right (-y would be y rows to the left) of the reference Ref.
- The syntax for OFFSET is as follows: OFFSET(Reference,Rows,Columns,[Height],[Width])
- The arguments in square brackets (Height and Width) can be omitted from the formula (they both have a default value of 1)
- OFFSET(F5,E12,E13) would take us two rows down and three columns to the left to cell C7. Therefore, OFFSET(F5,E12,E13) = 20
Lesson notes are only available for subscribers.