close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()