Discussion Re: Using the number in a cell as the row reference in other. in Excel
https://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1889639#M81155
<P><LI-USER uid="869917"></LI-USER> </P><P>The function that performs the task you describe is</P><P><STRONG>=INDIRECT("F"&D4)</STRONG></P><P>Another option is to use INDEX</P><P><STRONG>= INDEX(F:F, D4)</STRONG></P><P>I tend to use defined names rather than cell references e.g.</P><P><STRONG>= INDEX( data, instance )</STRONG></P><P>but that is a matter of personal preference.</P>Mon, 16 Nov 2020 07:31:48 GMTPeter Bartholomew2020-11-16T07:31:48ZUsing the number in a cell as the row reference in other.
https://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1889542#M81153
<P>I have a table to which I need to keep adding rows.</P><P>At the end of the table, I have several cells taking the values of the last row, and it makes me change the row number in then all every time I add a row.</P><P>It would help me a lot if I could could do this:</P><P>Let's say I want the value of F3 in E8.</P><P>Instead of writing =F3 in E8, I want to put the the row number 3 in D4 and write a formula in E8 that takes the column F and the row number 3 I wrote in D4.</P><P>Please, help</P><P> </P><P> </P>Mon, 16 Nov 2020 06:36:02 GMThttps://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1889542#M81153eviera492020-11-16T06:36:02ZRe: Using the number in a cell as the row reference in other.
https://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1889639#M81155
<P><LI-USER uid="869917"></LI-USER> </P><P>The function that performs the task you describe is</P><P><STRONG>=INDIRECT("F"&D4)</STRONG></P><P>Another option is to use INDEX</P><P><STRONG>= INDEX(F:F, D4)</STRONG></P><P>I tend to use defined names rather than cell references e.g.</P><P><STRONG>= INDEX( data, instance )</STRONG></P><P>but that is a matter of personal preference.</P>Mon, 16 Nov 2020 07:31:48 GMThttps://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1889639#M81155Peter Bartholomew2020-11-16T07:31:48ZRe: Using the number in a cell as the row reference in other.
https://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1890511#M81180
<P><LI-USER uid="869917"></LI-USER> </P>
<P>Most probably it's not necessary to enter row number, it could be calculatable. Especially if use Excel Tables, not ranges.</P>Mon, 16 Nov 2020 13:34:44 GMThttps://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1890511#M81180Sergei Baklan2020-11-16T13:34:44ZRe: Using the number in a cell as the row reference in other.
https://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1891644#M81214
<P><LI-USER uid="214174"></LI-USER> </P><P>Thanks! Peter!!</P><P>It works perfectly.</P><P>You've been so helpful.</P><P> </P>Mon, 16 Nov 2020 17:29:27 GMThttps://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1891644#M81214eviera492020-11-16T17:29:27ZRe: Using the number in a cell as the row reference in other.
https://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1891648#M81215
<P><LI-USER uid="521"></LI-USER> </P><P>Thanks a lot Sergei.</P><P>Perhaps this solution is better for people who knows more than I do.</P><P> </P>Mon, 16 Nov 2020 17:36:19 GMThttps://techcommunity.microsoft.com/t5/excel/using-the-number-in-a-cell-as-the-row-reference-in-other/m-p/1891648#M81215eviera492020-11-16T17:36:19Z