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

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

"(E-Mail Removed)" 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
>

On Dec 12, 11:51 am, Smallweed <Smallw...@discussions.microsoft.com>
wrote:
> if you're in F7, ROW() returns 7 which puts you in cell S12
>
>
>
> "pignata...@cox.net" 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- Hide quoted text -
>
> - Show quoted text -

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

Thanks

(E-Mail Removed) wrote:
> On Dec 12, 11:51 am, Smallweed <Smallw...@discussions.microsoft.com>
> wrote:
>
>>if you're in F7, ROW() returns 7 which puts you in cell S12
>>
>>
>>
>>"pignata...@cox.net" 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- Hide quoted text -
>>
>>- Show quoted text -
>
>
> Still not getting the result-how would you change formula?
>
> Thanks
After the 6 insert +1

Alan Beban

On Dec 12, 4:24 pm, Alan Beban <unavaila...@no.com> wrote:
> pignata...@cox.net wrote:
> > On Dec 12, 11:51 am, Smallweed <Smallw...@discussions.microsoft.com>
> > wrote:
>
> >>if you're in F7, ROW() returns 7 which puts you in cell S12
>
> >>"pignata...@cox.net" 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- Hide quoted text -
>
> >>- Show quoted text -
>
> > Still not getting the result-how would you change formula?
>
> > Thanks
>
> After the 6 insert +1
>
> Alan Beban- Hide quoted text -
>
> - Show quoted text -

THANKS!!!!