I'm trying use an INDIRECT formula to reference a table range in another sheet. The sheet name is called "TEMPLATE" and the table range is in cell C2 as seen below, "B8:CB51".
However, this is the error I get when I try to use the formula.
Why is this the case?? I've tried everything and my head is about to explode at the moment...
Here's the FILTER formula working fine if I dont use INDIRECT inside of it
However, this is the error I get when I try to use the formula.
Why is this the case?? I've tried everything and my head is about to explode at the moment...
Here's the FILTER formula working fine if I dont use INDIRECT inside of it