Forum Discussion
Solved
Auto update a cell ref with in text instruction
To help worksheets users, I write instructions in a cells at the end of relevant columns. Typically “Check that this value (i.e. the value calculated in the following cell) equals D54.” How can I m...
- Many thanks, from your response I was able to decipher the code and use in several other situations👍
= "Check that this value equals " & ADDRESS(ROW(D54), COLUMN(D54),4,)Or to prove that no formula is too trivial to be a Lambda function
= Instructionλ("Check that this value equals ", D56)
where
Instructionλ(text, ref)
= text & ADDRESS(ROW(ref), COLUMN(ref), 4)Thanks, worked a treat😊