Using the number in a cell as the row reference in other.

[eviera49]

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 add a row.

It would help me a lot if I could  could do this:

Let's say I want the value of F3 in E8.

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.

Please, help

[#2 · Accepted solution]

@eviera49 

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.

[#3]

@eviera49 

Most probably it's not necessary to enter row number, it could be calculatable. Especially if use Excel Tables, not ranges.

[#4]

@Peter Bartholomew 

Thanks! Peter!!

It works perfectly.

You've been so helpful.

[#5]

@Sergei Baklan 

Thanks a lot Sergei.

Perhaps this solution is better for people who knows more than I do.