formula question

[Guest]

this is continued from my post last week.. (9/27/2007)
I need Sheet 1 to look up sheet 2 so that I have the following;
D5 (sheet 1) = D14 (sheet2)
F5 = G14
H5 = J14 etc..
(so every 3rd column in sheet 2)
I am using the following formula
=INDEX('Sheet 2'!$14:$14,1+3*ROWS(A$1:A1))
however each cell i copy the formula into returns the value from D14 on
sheet 2??
Can anyone tell me what im doing wrong?...

 

[Guest]

I am having an absolute shocker of a day.. let me ammend my problem...

D5(Sheet 1) = D14 (sheet 2)
D6 = G14
D7 = J14 etc...
So i have rows in sheet 1 that need to look at every 3rd column in sheet 2..

 

[Guest]

dont worry guys. the formula actually worked, i was doing it wrong, sorry