How to get the value of the cell to its left on the 3rd row?

Could you tell me the formula (if any)
which is in a new location always takes the value of the cell that is 3 cells to the left
Thanks in advance!

That is, for example
Cell d4 = formula = a4
Cell f4 = formula = c4
June 14th 19 at 20:07
2 answers
June 14th 19 at 20:09
See the function offset (OFFSET)
June 14th 19 at 20:11
=A3, where A3 is the desired cell. Stretch in any direction

Find more questions by tags Excel