Offset function

[tiredofit]

If I have the values 1,2,3,4,5 in column A, values a,b,c,d,e in column B, values e,f,g,h,i in column C, then if I type (in any cell on the worksheet) the formula:

= Offset(A1, 1, 1)

I get the value of b because it starts at cell A1, moves 1 row down, then 1 column right to cell B2.

What is the significance of the 3rd and 4th args in the formula?

For example, what would this return?

= Offset(A1,1,1,2,2)

Thanks

 

[sandy666]

OFFSET() description