Referencing a cell dynamically

I have a cell that is named "term" and is assigned a number value by the user. I was wondering if there was a way to give a different cell the value of the cell that is in row Column J row number Term+13
In other words
the contents of cell "J"&Term+13
is this possible?

=indirect("J"&term+13)



jliz2803 wrote:
>
> I have a cell that is named "term" and is assigned a number value by the
> user. I was wondering if there was a way to give a different cell the
> value of the cell that is in row Column J row number Term+13
> In other words
> the contents of cell "J"&Term+13
> is this possible?
>
> --
> jliz2803
> ------------------------------------------------------------------------
> jliz2803's Profile: http://www.excelforum.com/member.php...o&userid=31498
> View this thread: http://www.excelforum.com/showthread...hreadid=512408

--

Dave Peterson

Thank you so much for your help

Try this:

=INDEX(J:J,term+13)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"jliz2803" <[email protected]> wrote in
message news:[email protected]...
>
> I have a cell that is named "term" and is assigned a number value by the
> user. I was wondering if there was a way to give a different cell the
> value of the cell that is in row Column J row number Term+13
> In other words
> the contents of cell "J"&Term+13
> is this possible?
>
>
> --
> jliz2803
> ------------------------------------------------------------------------
> jliz2803's Profile:
http://www.excelforum.com/member.php...o&userid=31498
> View this thread: http://www.excelforum.com/showthread...hreadid=512408
>