offset excel function

Offset excel function: Formula, Examples, and Free video

Offset excel function

Excel offset function is a very interesting function that helps in getting data based on four parameters. These parameters are height, width, rows, and columns. Where VLOOKUP and HLOOKUP can get value from one side only, OFFSET can get value from any side. There is a lot of flexibility with OFFSET as compared to other lookup functions in excel.

OFFSET function syntax

Let us understand how OFFSET function works. The OFFSET function syntax is given below.

Offset excel function
Offset excel function

In the above image we can see the inputs, reference means the reference from which the base is to be offset. It can be a cell or a range of adjacent cells. rows rows to move from starting … Continue Reading