View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyer
 
Posts: n/a
Default 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