Feb 06 2022 07:48 PM
Feb 06 2022 11:24 PM
@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.