Hi,

Put this in AG2 and drag righ and it will increment the row

=INDIRECT("Fig!K"&COLUMN(J1))

Mike

"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?