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.
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