Forum Discussion
Solved
Using the number in a cell as the row reference in other.
I have a table to which I need to keep adding rows. 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 ad...
The function that performs the task you describe is
=INDIRECT("F"&D4)
Another option is to use INDEX
= INDEX(F:F, D4)
I tend to use defined names rather than cell references e.g.
= INDEX( data, instance )
but that is a matter of personal preference.
Most probably it's not necessary to enter row number, it could be calculatable. Especially if use Excel Tables, not ranges.
Thanks a lot Sergei.
Perhaps this solution is better for people who knows more than I do.
