Using Offset in Excel

=OFFSET(A1,5,0)



In the above example excel will use the value in A6 by taking A1 as reference and moving the cursor down 5 rows and 0 coulmns.