Is it possible to use the value of a cell as a reference to another cell?

Question

Google Sheets

Let's say I have the value C4 in cell A1, and it changes.
I need to refer from the formula to the cell whose index is written in A1.
So far, instead of the content of C4, I have been persistently using the content of A1, the text value "C4".
How can i do this?

Answer 1

If you need to copy the value from C4 , then
=C4
If you need to copy the value at the address that lies in A1 , i.e. from " C4 ", then
=ДВССЫЛ(A1)
or
=INDIRECT(A1)