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

2

2

25hp2017-10-04 19:25:21

excel

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

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

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

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

Similar questions

P

powercoder2019-12-09 20:25:26

How to sort a table with a list of the same values in descending order? 1Reply

B

Bream23192017-07-12 15:55:47

How to solve the problem with the slow work of heavy Microsoft Excel files? 1Reply

M

Maxim Tyulpakov2015-08-14 10:45:10

How to sort date in Excel? 2Reply

A

Artem Morozov2019-12-22 09:59:20

How to correctly calculate the amount if some cells contain N/A? 1Reply

L

lightglams2017-07-27 16:51:29

How to subtract 30% from a number with a formula in excel, then add 25%? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question