What am I missing here???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pignataro1@cox.net - 12 Dec 2007 16:24 GMT

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

Reply to this Message

Smallweed - 12 Dec 2007 16:51 GMT

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

> Good morning all,
>
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message

pignataro1@cox.net - 12 Dec 2007 20:27 GMT

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
>
[quoted text clipped - 17 lines]
>
> - Show quoted text -

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

Thanks

Reply to this Message

Alan Beban - 12 Dec 2007 21:24 GMT

> On Dec 12, 11:51 am, Smallweed <Smallw...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 25 lines]
>
> Thanks

After the 6 insert +1

Alan Beban

Reply to this Message

pignataro1@cox.net - 12 Dec 2007 22:11 GMT

> pignata...@cox.net wrote:
> > On Dec 12, 11:51 am, Smallweed <Smallw...@discussions.microsoft.com>
[quoted text clipped - 32 lines]
>
> - Show quoted text -

THANKS!!!!

Reply to this Message