I have the following:
cell G1 = A2
cell G2 = A4
cell G3 = A6

Is there a way to have this go all the way down the column. I know if the
cells equaled A2, A3, A4 I could just drag it down but it doesn't work in
this case. Any ideas? Thanks

Try the following formula

=INDIRECT("A"&ROW()*2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jambruins" wrote in
message
...
I have the following:
cell G1 = A2
cell G2 = A4
cell G3 = A6

Is there a way to have this go all the way down the column. I
know if the
cells equaled A2, A3, A4 I could just drag it down but it
doesn't work in
this case. Any ideas? Thanks

Actually this is what the exact cells a

G1:=ODDS!C2
G2:=ODDS!C4
G3:=ODDS!C6

How would I alter the formula you provided me with in this case? Thanks.

"Chip Pearson" wrote:

Try the following formula

=INDIRECT("A"&ROW()*2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jambruins" wrote in
message
...
I have the following:
cell G1 = A2
cell G2 = A4
cell G3 = A6

Is there a way to have this go all the way down the column. I
know if the
cells equaled A2, A3, A4 I could just drag it down but it
doesn't work in
this case. Any ideas? Thanks

Hi!

Try this:

=INDEX(odds!C:C,(ROWS($1:2)-1)*2)

Biff

"Jambruins" wrote in message
...
Actually this is what the exact cells a

G1:=ODDS!C2
G2:=ODDS!C4
G3:=ODDS!C6

How would I alter the formula you provided me with in this case? Thanks.

"Chip Pearson" wrote:

Try the following formula

=INDIRECT("A"&ROW()*2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jambruins" wrote in
message
...
I have the following:
cell G1 = A2
cell G2 = A4
cell G3 = A6

Is there a way to have this go all the way down the column. I
know if the
cells equaled A2, A3, A4 I could just drag it down but it
doesn't work in
this case. Any ideas? Thanks

Try:

=INDIRECT("ODDS!C"&ROW(1:1)*2)

HTH
JG

"Jambruins" wrote:

Actually this is what the exact cells a

G1:=ODDS!C2
G2:=ODDS!C4
G3:=ODDS!C6

How would I alter the formula you provided me with in this case? Thanks.

"Chip Pearson" wrote:

Try the following formula

=INDIRECT("A"&ROW()*2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jambruins" wrote in
message
...
I have the following:
cell G1 = A2
cell G2 = A4
cell G3 = A6

Is there a way to have this go all the way down the column. I
know if the
cells equaled A2, A3, A4 I could just drag it down but it
doesn't work in
this case. Any ideas? Thanks

chip, biff, and pin, thanks for the help!

"pinmaster" wrote:

Try:

=INDIRECT("ODDS!C"&ROW(1:1)*2)

HTH
JG

"Jambruins" wrote:

Actually this is what the exact cells a

G1:=ODDS!C2
G2:=ODDS!C4
G3:=ODDS!C6

How would I alter the formula you provided me with in this case? Thanks.

"Chip Pearson" wrote:

Try the following formula

=INDIRECT("A"&ROW()*2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jambruins" wrote in
message
...
I have the following:
cell G1 = A2
cell G2 = A4
cell G3 = A6

Is there a way to have this go all the way down the column. I
know if the
cells equaled A2, A3, A4 I could just drag it down but it
doesn't work in
this case. Any ideas? Thanks