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