# Formula to Fill Down that picks up columns

#### JamesKM

##### Board Regular
I have a workbook set up as follows:

Sheet1:
Row 1: Month (Jan, Jan, Jan, Feb, Feb, Feb etc - 3 for each month)
Row 2: Budget, Actual, Difference, (repeated for each month)
Row3: contains a sum of the rows below for each of the budget, actual and difference.

Sheet2:
ColumnA: Title is Month, data is Jan, Feb, Mar etc
ColumnB: Tilte is Budget, data is to be Sheet1!B3, Sheet1!E3, Sheet1!H3 etc
ColumnC: Title is Actual, data is to be Sheet1!C3, Sheet1!F3, Sheet1!I3 etc

So, I would like to know if it possible to have a formula that specifies the row and adds 3 to the "Base" column each time that I can put in a fill down.

thanks in advance for any guidance,

James

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
try using the offset function;

Code:
``=OFFSET(Sheet1!\$A\$1,2,((ROW()-1)*3)-2)``

This will work for row 3 but you will need to play around if the row if you want to return data from another row, post back if you are not sure.

Worked perfectly (with adjustment as you sugested - thanks very much

James

Replies
1
Views
230
Replies
30
Views
938
Replies
5
Views
417
Replies
19
Views
344
Replies
3
Views
736

### Forum statistics

1,203,491
Messages
6,055,727
Members
444,814
Latest member
AutomateDifficulty

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back