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. Sorry, I didn't catch. Is that like this?
