I have a cell that is named quot;termquot; 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 quot;Jquot;amp;Term 13
is this possible?--
jliz2803
------------------------------------------------------------------------
jliz2803's Profile: www.excelforum.com/member.php...oamp;userid=31498
View this thread: www.excelforum.com/showthread...hreadid=512408=indirect(quot;Jquot;amp;term 13)
jliz2803 wrote:
gt;
gt; I have a cell that is named quot;termquot; and is assigned a number value by the
gt; user. I was wondering if there was a way to give a different cell the
gt; value of the cell that is in row Column J row number Term 13
gt; In other words
gt; the contents of cell quot;Jquot;amp;Term 13
gt; is this possible?
gt;
gt; --
gt; jliz2803
gt; ------------------------------------------------------------------------
gt; jliz2803's Profile: www.excelforum.com/member.php...oamp;userid=31498
gt; View this thread: www.excelforum.com/showthread...hreadid=512408
--
Dave Peterson
Try this:
=INDEX(J:J,term 13)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;jliz2803quot; gt; wrote in
message ...
gt;
gt; I have a cell that is named quot;termquot; and is assigned a number value by the
gt; user. I was wondering if there was a way to give a different cell the
gt; value of the cell that is in row Column J row number Term 13
gt; In other words
gt; the contents of cell quot;Jquot;amp;Term 13
gt; is this possible?
gt;
gt;
gt; --
gt; jliz2803
gt; ------------------------------------------------------------------------
gt; jliz2803's Profile:
www.excelforum.com/member.php...oamp;userid=31498
gt; View this thread: www.excelforum.com/showthread...hreadid=512408
gt;
Thank you so much for your help--
jliz2803
------------------------------------------------------------------------
jliz2803's Profile: www.excelforum.com/member.php...oamp;userid=31498
View this thread: www.excelforum.com/showthread...hreadid=512408
- May 16 Wed 2007 20:37
Referencing a cell dynamically
close
全站熱搜
留言列表
發表留言