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