Hello and thank you for looking at this.
I have just started using INDIRECT and am finding it very challenging. I have a couple of use cases. One I have solved, this new one is killing me on syntax.
I am using a dropdown to change a year. When it changes my formula updates to reference a new...