Formula to get a cell value based on row and column

[plans]

Hi,
I am trying to come up with a formula based on row and column numbers; say I have a value in cell A1, I am trying to get something like = Cell(1,1).
What would be the right formula for this
Thank you

[daffodil11]

=indirect(address(1,1))

[Jonmo1]

Try

=INDEX($A:$XFD,1,1)

[martindwilson]

and just in case you're confused

=INDEX($A:$XFD,1,1) will change to

=INDEX($1:$1048576,1,1) when entered ie all the cells in the work sheet

[Jonmo1]

=INDEX($A:$XFD,1,1) will change to

=INDEX($1:$1048576,1,1) when entered ie all the cells in the work sheet

I wonder why it does that? A:XFD is also a reference to all the cells in the sheet...

Similarly, but opposite really...
A1:A1048576 will change to A:A