Offset uses reference point, how far down, how far right, and what size
(optional)
For you:
=OFFSET(Fig!K10,COLUMN(A$1)-1,0)
This says to look at K10, then move x amount of rows down, where x equals
the column of A1-1 (0), thus returning K10. When you copy to the right, x
becomes column of B1 (2) - 1 = 1, thus returning K11.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Seanie" wrote:

Could someone help me figure out the offset function

I have a reference in cell AG2 of =Fig!K10, I want to drag this to AS2
with values of =Fig!K11; =Fig!K12 etc etc

How can I do that without entering all these references manually?