What am I missing here???

[pignataro1]

Good morning all,

Cannot figure out what I am missing here.

This is in cell F6

='VT by Brand 07-09'!S7

This is in cell F7

=INDIRECT("'VT by Brand 07-09'!S"&(ROW()-5)*6)

This should go down 6 rows to S13 on "VT by Brand 07-09 page and
retrieve data but it is 1 row short-What am I missing here???

Thanks

 

[Smallweed]

if you're in F7, ROW() returns 7 which puts you in cell S12

 

[pignataro1]

if you're in F7, ROW() returns 7 which puts you in cell S12












- Show quoted text -

Still not getting the result-how would you change formula?

Thanks

 

[Alan Beban]

Still not getting the result-how would you change formula?

Thanks

After the 6 insert +1

Alan Beban

 

[pignataro1]

After the 6 insert +1

Alan Beban- Hide quoted text -

- Show quoted text -

THANKS!!!!