Output cell value given cell address

[jfleeger]

Need some help with this.

I am trying to output a cell's value given the cell's address found from a formula in another cell. Is this possible ?

Here's an example:

<table width="136" border="0" cellpadding="0" cellspacing="0"><col style="width: 54pt;" width="72"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 18pt;" height="24"> <td class="xl26" style="height: 18pt; width: 54pt;" width="72" height="24"> <table width="269" border="0" cellpadding="0" cellspacing="0"><col style="width: 99pt;" width="132"> <col style="width: 55pt;" width="73"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 18pt;" height="24"> <td style="height: 18pt; width: 99pt;" width="132" height="24">
</td> <td class="xl26" style="width: 55pt;" width="73"> A</td> <td class="xl25" style="width: 48pt;" width="64"> B</td> </tr> <tr style="height: 18pt;" height="24"> <td style="height: 18pt;" align="right" height="24">1</td> <td align="center">25</td> <td align="center">50</td> </tr> <tr style="height: 18pt;" height="24"> <td style="height: 18pt;" align="right" height="24">2</td> <td class="xl24" align="center">30</td> <td class="xl24" align="center">60</td> </tr> </tbody></table></td> <td class="xl25" style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 18pt;" height="24"> <td class="xl26" style="height: 18pt;" height="24">
</td> <td class="xl24" align="left">
</td> </tr> </tbody></table>So, I found from from the cell "address" and "row" functions, the address: $A$2

Now, I need a formula that will output "30", the value of $A$2.

Thanks !!
James

 

[sheetspread]

=Indirect()

 

[Arul.rajesh]

=indirect(address(1,2))

 

[jefleeger]

Works great !! Appreciate the help !!

 

[Scott Huish]

What was your original formula?

 

[jefleeger]

I was using the address function only. I did not know the Indirect() function existed, but it was the additional function I needed to output the value of the cell.

 

[Scott Huish]

My point is why are you using a formula that returns an address and then using INDIRECT? There more be a more direct way of accomplishing what you are trying to do.

 

[jefleeger]

Maybe there is, but this works perfectly in one function.