Offset function

Hi Hamish,

Thank you for your question.

The Offset function returns a reference to a range that is offset a number of rows and columns from another range or cell.

e.g. If you take this formula, = offset(a1,2,2), excel will start in cell a1 and display the value in the cell that is 2 rows down and 2 columns across from a1 (cell c3).

I hope this answers your question.

Regards

Simon