From: sebastien972 on

Hi, first off, first post and thank you for being such a great
community. Also, I might need your help as I am facing a wall. You guys
are bulldozers so it should be easy enough.

Alright, I am using Excel 2003 and I am trying to automatically fill a
VLookup formula in different cells that are not adjacent to each other.


Every cell has a lap of 6 cells in between. So after getting the
original formula from my first cell I get

=VLOOKUP('sky.com PIPS'$E5,'sky.Com PIPS'$E$5:$E$28,1,FALSE)

now when doing Ctrl + left click to go down to the 6th cell below where
i need to be I get

=VLOOKUP('sky.com PIPS'$E12,'sky.Com PIPS'$E$5:$E$28,1,FALSE)

now what I am trying to get is

=VLOOKUP('sky.com PIPS'$E6,'sky.Com PIPS'$E$5:$E$28,1,FALSE)

Please help, thanks !


--
sebastien972
------------------------------------------------------------------------
sebastien972's Profile: http://www.thecodecage.com/forumz/member.php?u=1820
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=199864

http://www.thecodecage.com/forumz

From: Pete_UK on
You could do what you want using INDIRECT and a bit of maths, but
rather than give you that formula can you explain what you are trying
to do? Why are you using VLOOKUP? Your first formula will return
'sky.Com PIPS'!E5 and the second one (the one you want) will return E6
from that sheet, so why not just have a simple link to the required
cell?

Pete

On Apr 30, 8:42 pm, sebastien972 <sebastien972.4a8...(a)thecodecage.com>
wrote:
> Hi, first off, first post and thank you for being such a great
> community. Also, I might need your help as I am facing a wall. You guys
> are bulldozers so it should be easy enough.
>
> Alright, I am using Excel 2003 and I am trying to automatically fill a
> VLookup formula in different cells that are not adjacent to each other.
>
> Every cell has a lap of 6 cells in between. So after getting the
> original formula from my first cell I get
>
> =VLOOKUP('sky.com PIPS'$E5,'sky.Com PIPS'$E$5:$E$28,1,FALSE)
>
> now when doing Ctrl + left click to go down to the 6th cell below where
> i need to be I get
>
> =VLOOKUP('sky.com PIPS'$E12,'sky.Com PIPS'$E$5:$E$28,1,FALSE)
>
> now what I am trying to get is
>
> =VLOOKUP('sky.com PIPS'$E6,'sky.Com PIPS'$E$5:$E$28,1,FALSE)
>
> Please help, thanks !
>
> --
> sebastien972
> ------------------------------------------------------------------------
> sebastien972's Profile:http://www.thecodecage.com/forumz/member.php?u=1820
> View this thread:http://www.thecodecage.com/forumz/showthread.php?t=199864
>
> http://www.thecodecage.com/forumz

From: sebastien972 on

Thank you for your reply,

I am trying to automatize pasting a formula that would allow me to use
the data from the second picture's page and to insert it in the main
page representated by the first picture.

My goal is to to get the Sky.com pips for each C9-C16-24 cells and so
on.. for everyday of the week.

Thanks for your help, I really appreciate,

[image: http://i940.photobucket.com/albums/ad250/sebastien972/exc1.jpg]

[image: http://i940.photobucket.com/albums/ad250/sebastien972/exc2.jpg]


--
sebastien972
------------------------------------------------------------------------
sebastien972's Profile: http://www.thecodecage.com/forumz/member.php?u=1820
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=199864

http://www.thecodecage.com/forumz

From: Simon Lloyd on

sebastien972, you chose to post your question in the newsgroups section
of these forums and with that comes some limitations, the good folk at
the newsgroups will NOT be able to view your pictures or attachments as
these don't get transmitted, they would physically have to visit this
site and this thread to view them, some may do that but most will
decline.


You may have to better describe your problem in words to illustrate your
problems and goals.


s
e
b
a
s
t
i
e
n
9
7
2
;
7
1
4
0
7
1

W
r
o
t
e
:


>
Thank you for your reply,

I am trying to automatize pasting a formula that would allow me to use
the data from the second picture's page and to insert it in the main
page representated by the first picture.

My goal is to to get the Sky.com pips of the C column on the 2nd picture
to increasingly fit in the C9-C16-24 cells and so on.. for everyday of
the week pages.

Thanks for your help, I really appreciate,

[image: http://i940.photobucket.com/albums/ad250/sebastien972/exc1.jpg]

[image: http://i940.photobucket.com/albums/ad250/sebastien972/exc2.jpg]


--
Simon Lloyd

Regards,
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?u=1
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=199864

http://www.thecodecage.com/forumz

From: sebastien972 on

Oh sorry about that, I am just trying to be as descriptive as possible.

Please continue to help me.

My goal is to to get the numbers from the 'Sky.Com PIPS' sheet C column
to automatically fit in the cells corresponding to their respective
letters in the 'Saturday' sheet, column C as well. However, the cells
that I need to fill in 'Saturday' sheet are separated by 6 cells
intervals, so i cannot Drag + fill formulas.

For example, I would need 'Sky.Com PIPS'!C5 to show in 'Saturday'!C9,
then 'Sky.Com PIPS'!C6 to show in 'Saturday'!C16, then 'Sky.Com PIPS'!C7
to show in 'Saturday'!C24 and so on...

Thank you for your time


--
sebastien972
------------------------------------------------------------------------
sebastien972's Profile: http://www.thecodecage.com/forumz/member.php?u=1820
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=199864

http://www.thecodecage.com/forumz