Forum Discussion
Filter function help with structured references
Hi, I’m trying to use filter function to filter a table from another worksheet so that when data gets copied into the table the other worksheet updates. It works fine with cell references but I want ...
Katie_Be Difficult to answer if you don't show the formula that returns the value error or the table the formula references. Structured references are a bit tricky to write from scratch, but if you create the formula by selecting the ranges inside the structure table, Excel will automatically include the right syntax. With a table called "Table1" such a formula could look like this 8just as an example):
Once you have a structured table, you no longer need to include the sheet name when you enter the formula in another sheet. In. other words, it doesn't matter where the table sits in the workbook. As long as you spell the table and column names correctly, Excel will find the data.