Issues with VLookup, Please help!
in [General]
|
From: sebastien972 on 30 Apr 2010 15:42 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 30 Apr 2010 15:59 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 30 Apr 2010 16:32 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 30 Apr 2010 17:08 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 30 Apr 2010 17:28
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 |