Referencing a cell dynamically

J

jliz2803

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

Dave Peterson

=indirect("J"&term+13)


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?
Click to expand...
 
R

RagDyer

Try this:

=INDEX(J:J,term+13)

--
HTH,

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