Copying fomula down...

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" <Jambruins@discussions.microsoft.com> wrote in
message
news:8DD968DF-4F65-4EAF-8A84-33CFE09A60C7@microsoft.com...
>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 are:

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" <Jambruins@discussions.microsoft.com> wrote in
> message
> news:8DD968DF-4F65-4EAF-8A84-33CFE09A60C7@microsoft.com...
> >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" <Jambruins@discussions.microsoft.com> wrote in message
news:5FD2284D-B75D-4515-BBED-49B01C79C004@microsoft.com...
> Actually this is what the exact cells are:
>
> 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" <Jambruins@discussions.microsoft.com> wrote in
>> message
>> news:8DD968DF-4F65-4EAF-8A84-33CFE09A60C7@microsoft.com...
>> >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 are:
>
> 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" <Jambruins@discussions.microsoft.com> wrote in
> > message
> > news:8DD968DF-4F65-4EAF-8A84-33CFE09A60C7@microsoft.com...
> > >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 are:
> >
> > 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" <Jambruins@discussions.microsoft.com> wrote in
> > > message
> > > news:8DD968DF-4F65-4EAF-8A84-33CFE09A60C7@microsoft.com...
> > > >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
> > >
> > >
> > >