Put in a formula a constant + a variable

[Excel Semplicemente]

Good afternoon guys,

I have in the sheet A some constant cells that I renamed using the Name Box (typing Constant_1, Constant_2, and so on).

Now I'm trying to copy these constants into the same sheet but in a particular column.

In order to do that, I'd like to write in the first cell of the column the first constant using the reference to the cell named Constant_1.
Is it possible to write a formula such that dragging it I can copy automatically the other constants (Constant_2, Constant_3 and so on)?

Thank you in advance,

Nicola

 

[Eric W]

Try:

Book1
	A	B	C	D
1	1			Constants
2				1
3	2			2
4				3
5	3			A
6				4
7	A			#REF!
8
9	4
Sheet16

Cell Formulas
Range	Formula
D2:D7	D2	=INDIRECT("Constant_"&ROWS($D$2:$D2))

 

[Excel Semplicemente]

Thank you @Eric W!
I was starting to doubt that there were a simple solution!

 

[Eric W]

Glad it works for you! ?