Hello

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

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

asked June 14th 19 at 20:07

2 answers

answered on June 14th 19 at 20:09

See the function offset (OFFSET)

answered on June 14th 19 at 20:11

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

Find more questions by tags Excel