Forum Discussion
Referencing Sheet Names in a Dynamic Table
I'd like some help resolving a reference error in a formula designed to use Sumif across multiple sheets. Here's the problem statement: a) I'm developing Workbook for managing vendors and con...
The inner bit of your first INDIRECT function in your first formula resolves to:
='Vendor_Table[[#All],[Vendor Worksheet]]'!C3
which is not a valid reference to a range of cells.
='Vendor_Table[[#All],[Vendor Worksheet]]'!C3
which is not a valid reference to a range of cells.
Is there an easy way to fix it? The INDIRECT is set up the same in both examples, so I'm assuming there is an adjustment made necessary because one is a table column and the other is a static list, but I'm stuck as to what that would be.
- Not familiar with your setup, but what if you remove this bit: &"!C3"