Function OFFSET

Description

Let's take a look at one very interesting function called OFFSET.

Function OFFSET (СМЕЩ) is in the category References and arrays (Lookup and Reference) and can create a reference to a range of a given size at a given location in the sheet and has the following arguments:

Some starting cell is taken as a starting point, then a shift relative to it by a given number of rows down and columns to the right is set. The last two arguments of this function are the height and width of the range we need. So, for example, if we wanted to reference a range of data with rates for 5 days starting on January 4th, we could use our function OFFSET with the following arguments:

=OFFSET(A3; 4; 1; 5; 2)

Also, the constants in this formula can be replaced with cell references, thus creating a dynamic named range on which to build dynamic drop-down lists .

Related Articles:

• Linked drop-down lists (using OFFSET)