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