Thanks Bob!
I may use the offset option provided by another poster, but this is what I
had been attempting to do- no way I could have figured your formula out by
myself!

Keith

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:eA9nVdk2FHA.2796@tk2msftngp13.phx.gbl...
>
> =INDIRECT(LEFT(ADDRESS(ROW(),B1,4,TRUE),1+(B1>26))&"11")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "KR" <nospam@nospam.com> wrote in message
> news:eb4ovMk2FHA.3156@TK2MSFTNGP10.phx.gbl...
> > A1 notation is the standard for our organization, so I'm looking for an
> > answer that maintains A1 notation.
> >
> > I have a cell that contains a number (20 to 115 or higher). I need to
pull
> a
> > value from the associated column.
> >
> > So, I have a reference cell B1 that contains the number 27, and I need
the
> > number in row 11.. I start my destination cell formula with:
> > =indirect("AA" & "11")
> >
> > Now I need to replace the "AA" with a link to the source cell (B1,
> > containing the number 27), but transmute the number so that it returns
> > columns T through however many columns are used (AA, AF, BR, etc.). What
> is
> > the best way to do this if forced to maintain A1 notation?
> >
> > =indirect(what_goes_here(B1) & "11")
> >
> > Thanks!
> > Keith
> >
> > --
> > The enclosed questions or comments are entirely mine and don't represent
> the
> > thoughts, views, or policy of my employer. Any errors or omissions are
my
> > own.
> >
> >
>
>