Referencing Excell address with numbers

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
LVL 13
Shanan212Asked:
Who is Participating?
 
NorieConnect With a Mentor VBA ExpertCommented:
Perhaps.

=OFFSET($A$1, 51,4)
0
 
Shanan212Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.