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?...