<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I ran into a small problem. This must be done via formulas as other options are limited.<br />
<br />
How do I retrive the contents of the cells using the cell's row and column number only?<br />
<br />
Eg;<br />
<br />
I know the cell is in column 5, row 52. How can I write a formula to retrive the contents inside this cell? (E52)?<br />
<br />
Thanks
</div>
</div>


Hi,

I ran into a small problem. This must be done via formulas as other options are limited.

How do I retrive the contents of the cells using the cell's row and column number only?

Eg;

I know the cell is in column 5, row 52. How can I write a formula to retrive the contents inside this cell? (E52)?

Thanks

Referencing Excell address with numbers

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.