return a value based on a given cell address

Question

I am going to retrieve the numbers every other ten rows in a column. I create a list of address of the cells that I want to retrieve

$A$2

$A$22

$A$32

$A$42

$A$52

...

However, I do not know how to read the numbers within the cells with the address. Or is there other simple way to do it without reading the address?

Thanks.

Answer 1

With $A$2 in Cell B2 you cluld use a formula like this

=indirect(B2)

Note that this formula is volatile and has high calculation overhead. A better solution might be to put the number 2 in Cell C2 and use a formula such as this

=index($A$1:$A$1000, C2)

---

If this post answers your question, please mark it as the Answer... Jim Thomlinson

Answer 2

thanks alot