formula question

S

Scott R

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

Scott R

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top