Forum Discussion

BNewman's avatar
BNewman
Occasional Reader
Dec 15, 2025

Program a cell reference from another sheet

I need to be able to take the formula "=sheet2!c12" and be able to change the "C" in the formula many times in the worksheet so I don't have to change it manually across the rows. I want a cell that will be able to change the "=sheet2!c12" C reference throughout anywhere I've programmed this. I was going to use "find and replace" but that's not only nooby, it's going to wind up being buggy. Is there where an INDIRECT formula works? I think the answer should be simple. Thanks!

Formulas and Functions

1 Reply

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 16, 2025
    =INDIRECT(ADDRESS(12,COLUMN(INDIRECT(A1&"1")),,,"sheet2"))

    In cell A1 enter the letter of the column e.g. C, D or E....

Resources