Use Cell Value as Cell Reference in Function

[srcera]

Good Day,

Is it possible to use a cell's value as a reference for a function in another cell?

For example, is it possible to have the following:

A, 1, =A1
A, 4, =B4
C, 7, =C7

Thanks!

 

[VoG]

Try INDIRECT. Example

Excel Workbook
	A	B	C	D
1	777	A	1	777
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =A1<0	Abc

 

[srcera]

That's it. Thanks!