Offset Function/ Offset Formula Excel

Offset:

If the hlookup and vlookup belong to one family then one can say Match and Offset belong to the other one.

Offset is a pretty simple formula to be used in excel. However, as a suggestion from my end, one needs to use it in small data workbooks else, it becomes pretty tricky.

The syntax and its description is given below -

Offset(reference, rows, cols, [height], [width]) where,

reference - is a (output) cell or a range of adjacent cells from which you want to base the offset

rows - stands for no. of rows one wants to move up or down from the reference cell. +ve value denotes moving down and vice-versa

columns - stands for no. of coolumns one wants to move right or left from the reference cell. +ve value denotes moving right and vice-versa

[height] - which is optional and represents the number of rows selected. it has to be a positive value.

[width] - which is optional and represents the number of columns selected. it has to be a positive value.