Posted to microsoft.public.excel.worksheet.functions
|
|
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
|