Formula issues

[Ric]

Hello,
I have the following formula in a workbook on the first sheet that
references a 2nd sheet
in B6='VT by Brand 07-09'!F2
in B7 I want to go 6 rows down and currently have this formula=INDIRECT
(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))
I want to continue all the way down to B38 going 6 rows down each
time.



I have the same situation in C6='VT by Brand 07-09'!F4
in C7 I want to go 6 rows down and currently have this formula=INDIRECT
(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))
I want to continue all the way down to B38 going 6 rows down each
time.


I have the same situation in F6='VT by Brand 07-09'!F3
in F7 I want to go 6 rows down and currently have this formula=INDIRECT
(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))
I want to continue all the way down to B38 going 6 rows down each
time.

I have the same situation in G6='VT by Brand 07-09'!F5
in G7 I want to go 6 rows down and currently have this formula=INDIRECT
(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))
I want to continue all the way down to B38 going 6 rows down each
time.

What are the problems here???

Thanks

 

[Jacob Skaria]

Ric, kindly mention where you are facing an issue?

 

[Tom Hutchins]

In all of your row 7 formulas, you ned to change the second argument in your
ADDRESS functions. Column F is 6; you have 5, which is column E.

With that change, the B7 formulas works as intended. For the other columns,
you need to tweak the number of rows you are subtracting in your first
argument for the ADDRESS functions. Try these:

in B7: =INDIRECT(ADDRESS((ROW()-5)*6-4,6,,,"VT by Brand 07-09"))
in C7: =INDIRECT(ADDRESS((ROW()-5)*6-2,6,,,"VT by Brand 07-09"))
in F7: =INDIRECT(ADDRESS((ROW()-5)*6-3,6,,,"VT by Brand 07-09"))
in G7: =INDIRECT(ADDRESS((ROW()-5)*6-1,6,,,"VT by Brand 07-09"))

Then, copy the row 7 formulas down through row 38.

Hope this helps,

Hutch