What am I missing here???
 

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

What am I missing here???
 

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

" wrote:

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