Forum Discussion
Indirect function issues
Hi everyone, The following formula gives an error as soon as the INDIRECT function is added (see picture). Can someone help me with this ?
I will offer the help that getting the right syntax for INDIRECT, as is true for many of the more advanced functions, can be elusive. And it's virtually impossible (at least for me) to diagnose based solely on the image you provide, without knowing what you even mean by "as soon as the INDIRECT function is added" : what was there BEFORE it was added, for example?
Is it possible for you to post a copy of the actual spreadsheet on OneDrive or Google Drive, and post a link here that grants edit access to that spreadsheet? That would help us help you. But maybe, also, a clearer explanation of what you're wanting the INDIRECT function to yield in the way of a cell reference.
Is it possible for you to post a copy of the actual spreadsheet on OneDrive or Google Drive, and post a link here that grants edit access to that spreadsheet? That would help us help you. But maybe, also, a clearer explanation of what you're wanting the INDIRECT function to yield in the way of a cell reference.
