formula question
 

Hi there, im tring to write a formula to look at data from another worksheet
at every 3rd column so that I would have the following;



Sheet 1 A1 = Sheet 2 D14
A2 = G14
A3 = J14
A4 = M14 ETC...

Any help would be great :)

formula question
 

"Scott R" wrote...
Hi there, im tring to write a formula to look at data from another
worksheet at every 3rd column so that I would have the following;

Sheet 1 A1 = Sheet 2 D14
A2 = G14
A3 = J14
A4 = M14 ETC...

Sheet1!A1:
=INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1))

Fill Sheet1!A1 down as far as needed.

formula question
 

I put that formula in and it said there was an error, when i click ok it
refers back to the 1st of the 14's in the formula? Am i doing something wrong?

"Harlan Grove" wrote:

"Scott R" wrote...
Hi there, im tring to write a formula to look at data from another
worksheet at every 3rd column so that I would have the following;

Sheet 1 A1 = Sheet 2 D14
A2 = G14
A3 = J14
A4 = M14 ETC...

Sheet1!A1:
=INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1))

Fill Sheet1!A1 down as far as needed.

formula question
 

i might not have wrote it right in the beginning, what i have are rows in
sheet 1 that need to copy data from every 3rd Column in sheet 2

"Scott R" wrote:

I put that formula in and it said there was an error, when i click ok it
refers back to the 1st of the 14's in the formula? Am i doing something wrong?

"Harlan Grove" wrote:

"Scott R" wrote...
Hi there, im tring to write a formula to look at data from another
worksheet at every 3rd column so that I would have the following;

Sheet 1 A1 = Sheet 2 D14
A2 = G14
A3 = J14
A4 = M14 ETC...

Sheet1!A1:
=INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1))

Fill Sheet1!A1 down as far as needed.

formula question
 

Did you cut and paste the formula directly from Harlan's message, or did you
try to retype it?
Do you want to copy and paste the formula back from your formula bar to
here?

Is your Sheet2 actually named Sheet2? If it is Sheet 2 with a space, try
=INDEX('Sheet 2'!$14:$14,1+3*ROWS(A$1:A1))
--
David Biddulph

"Scott R" wrote in message
...
I put that formula in and it said there was an error, when i click ok it
refers back to the 1st of the 14's in the formula? Am i doing something
wrong?

"Harlan Grove" wrote:

"Scott R" wrote...
Hi there, im tring to write a formula to look at data from another
worksheet at every 3rd column so that I would have the following;

Sheet 1 A1 = Sheet 2 D14
A2 = G14
A3 = J14
A4 = M14 ETC...

Sheet1!A1:
=INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1))

Fill Sheet1!A1 down as far as needed.

formula question
 

David ive completely stuffed this up. this is what I need.
D5 (sheet 1) = D14 (sheet 2)
F5 = G14
H5 = J14 etc..
I pasted the formula in but it gives me the value from D14 for all cells
that i copy the formula into??


"David Biddulph" wrote:

Did you cut and paste the formula directly from Harlan's message, or did you
try to retype it?
Do you want to copy and paste the formula back from your formula bar to
here?

Is your Sheet2 actually named Sheet2? If it is Sheet 2 with a space, try
=INDEX('Sheet 2'!$14:$14,1+3*ROWS(A$1:A1))
--
David Biddulph

"Scott R" wrote in message
...
I put that formula in and it said there was an error, when i click ok it
refers back to the 1st of the 14's in the formula? Am i doing something
wrong?

"Harlan Grove" wrote:

"Scott R" wrote...
Hi there, im tring to write a formula to look at data from another
worksheet at every 3rd column so that I would have the following;

Sheet 1 A1 = Sheet 2 D14
A2 = G14
A3 = J14
A4 = M14 ETC...

Sheet1!A1:
=INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1))

Fill Sheet1!A1 down as far as needed.

formula question
 

Thanks guys, the formula worked, (i was doing it wrong).
Cheers

Scott

"Scott R" wrote:

David ive completely stuffed this up. this is what I need.
D5 (sheet 1) = D14 (sheet 2)
F5 = G14
H5 = J14 etc..
I pasted the formula in but it gives me the value from D14 for all cells
that i copy the formula into??


"David Biddulph" wrote:

Did you cut and paste the formula directly from Harlan's message, or did you
try to retype it?
Do you want to copy and paste the formula back from your formula bar to
here?

Is your Sheet2 actually named Sheet2? If it is Sheet 2 with a space, try
=INDEX('Sheet 2'!$14:$14,1+3*ROWS(A$1:A1))
--
David Biddulph

"Scott R" wrote in message
...
I put that formula in and it said there was an error, when i click ok it
refers back to the 1st of the 14's in the formula? Am i doing something
wrong?

"Harlan Grove" wrote:

"Scott R" wrote...
Hi there, im tring to write a formula to look at data from another
worksheet at every 3rd column so that I would have the following;

Sheet 1 A1 = Sheet 2 D14
A2 = G14
A3 = J14
A4 = M14 ETC...

Sheet1!A1:
=INDEX(Sheet2!$14:$14,1+3*ROWS(A$1:A1))

Fill Sheet1!A1 down as far as needed.