View Single Post
  #1   Report Post  
Jim May
 
Posts: n/a
Default Offset() relative addressing Row parameter

On sheet1 cell F90 I have =Offset('Sheet2'!$E$22,1,0)

I'd like to copy F90 to G90:M90
whereby the row parameter in F90
will increase by 1 with each column
for example J90 would have in it:
the equivalent of:
=Offset('Sheet2'!$E$22,5,0)

How should I alter my F90 to accomplish?
TIA,