Active cell as input to formula


This brings the selected cell reference. Use the INDIRECT function do do whatever you want with it from there on.

Note that simply selecting a cell won’t trigger the change. Once you select a cell, press F9 to calculate the sheet to get the proper results.