Offset function returns the reference to a range that is a given number of rows and columns from the given reference. Offset have five parameters. It also helps us to create dynamic ranges with the help of 4th and 5th parameter.
The syntax of Offset function
=Offset(Reference, Rows, Columns,[ Height], [Width])
Reference – Reference is any starting cell from where the offset will be applied.
Rows – The number of rows move down/up from the reference cell in the range.
Columns – The number of columns move Right/left from the reference cell in the range.
[Height] – The number of rows in the range. This is optional; if we leave this parameter then height will be a single cell.
[Width] – The number of columns in the range. This is optional; if we leave this parameter then height will be a single cell.
Based on the above example, offset function in cell F2 would return
=offset(B4,3,2) – “Yash Pal”(Would return the cell D7 value)