Issues with VLookup, Please help!

[sebastien972]

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

Alright, I am using Excel 2003 and I am trying to automatically fill
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 th
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 wher
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 !

 

[Pete_UK]

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

 

[sebastien972]

Thank you for your reply,

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

My goal is to to get the Sky.com pips for each C9-C16-24 cells and s
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]

 

[Simon Lloyd]

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


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


Thank you for your reply

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

My goal is to to get the Sky.com pips of the C column on the 2nd pictur
to increasingly fit in the C9-C16-24 cells and so on.. for everyday o
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)

 

[sebastien972]

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 colum
to automatically fit in the cells corresponding to their respectiv
letters in the 'Saturday' sheet, column C as well. However, the cell
that I need to fill in 'Saturday' sheet are separated by 6 cell
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'!C
to show in 'Saturday'!C24 and so on...

Thank you for your time

 

[teylyn]

Sebastien,

I doubt anyone will be able to help you on this, if you only suppl
screenshots.

First, you should lose the merged cells, because they will only lead t
trouble further down the track.

Secondly, post a workbook on this site www.thecodecage.com so people ca
actually test their suggestions without having to re-type your dat
setup from a screenshot. That will make yours and our lives easier.

Upload the file and specify what result you would like to see in whic
cell. Explain the logic that leads to the result. Provide a few mocke
up examples of results, so we can see if our formula suggestions wil
work.

cheers