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?


--
jliz2803
------------------------------------------------------------------------
jliz2803's Profile: http://www.excelforum.com/member.php...o&userid=31498
View this thread: http://www.excelforum.com/showthread...hreadid=512408

Referencing a cell dynamically
 

=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

Referencing a cell dynamically
 

Try this:

=INDEX(J:J,term+13)

--
HTH,

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


"jliz2803" wrote in
message ...

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

Referencing a cell dynamically
 

Thank you so much for your help


--
jliz2803
------------------------------------------------------------------------
jliz2803's Profile: http://www.excelforum.com/member.php...o&userid=31498
View this thread: http://www.excelforum.com/showthread...hreadid=512408