Forum Discussion
Excel CELL and ADDRESS functions help
The following function gives a VALUE! error =+CELL("content",G3) The cell G3 contains $C$3 which is the output of an ADDRESS function. Should this work?
I think you need =INDIRECT(G3)
Though I do not recommend INDIRECT as it is a function that always reclaculates and models which use INDIRECT are very hard to understand.
Though I do not recommend INDIRECT as it is a function that always reclaculates and models which use INDIRECT are very hard to understand.