How to take the value of a cell that is 3 rows to the left of it?

2

25hp2017-10-04 19:25:21

excel

25hp, 2017-10-04 19:25:21

Hello everyone
Tell me the formula (if there is one)
that always takes the value of the cell that is 3 cells to the left of it into a new cell
Thanks in advance!
That is, for example
Cell d4 = formula = a4
Cell f4 = formula = c4

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

K

kisaa, 2017-10-05
@kisaa

See OFFSET function

V

vladeol, 2017-10-04
@vladeol

=A3, where A3 is the desired cell. Stretch in any direction