Fix Excel INDEX #REF! Errors Caused by a Table Named Index
Question details
The user needs to fix an INDEX formula that returns a #REF! error because an Excel table is named Index.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains an Excel table named Index, and the user wants to use the INDEX function in a formula.
- Observed behavior
- Excel interprets Index as a table reference instead of the INDEX function, causing the formula to return #REF!.
Identify the table that is currently named Index before editing the formula. Table names must be unique and should not conflict with Excel function names.
Rename the Excel table currently named Index
Use this solution when the #REF! error appears because a table name conflicts with the INDEX function name.
Changing the table name removes the naming conflict so Excel can recognize INDEX as a worksheet function. Use a distinct table name such as tblIndex.
Click any cell inside the table named Index to display the Table Design tab on the Excel ribbon.
Open Table Design and select the Table Name box in the Properties group. Replace Index with a valid unique name, such as tblIndex, then press Enter.
Click the formula cell, press F2 or select the formula bar, and re-enter the formula using the function syntax, for example =INDEX(A1:A3,1). Press Enter to calculate it.

Check the formula for invalid or external references
Use this if #REF! remains after renaming the table, especially when Trace Error points to another workbook.
Rename conflicting table names and repair INDEX formulas in WPS Spreadsheets
WPS Spreadsheets provides table tools and formula editing controls to rename a table that conflicts with INDEX, then update the formula and verify its references in a familiar spreadsheet workspace.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, choose Spreadsheets, and open the Excel workbook containing the #REF! formula.
- 2. Select the conflicting table: Click a cell within the table named Index to display the available table tools on the ribbon.
- 3. Assign a unique table name: In the table name field under the table tools, replace Index with a name such as tblIndex and confirm the change.
- 4. Correct the INDEX formula: Select the formula cell, edit the formula in the formula bar, and enter a valid formula such as =INDEX(A1:A3,1).
- 5. Confirm the result: Press Enter and verify that the formula returns the expected value instead of #REF!.

Frequently Asked Questions
Why does naming a table Index cause a #REF! error?
Index can conflict with the INDEX worksheet function. When Excel interprets the name as a table reference rather than a function call, the formula may return #REF!. Rename the table from Table Design > Table Name.
What is a safe replacement name for a table called Index?
Use a unique name that does not match a function name, such as tblIndex, IndexData, or SalesIndex. Enter it in the Table Name box on the Table Design tab.
Why does my INDEX formula still show #REF! after I rename the table?
The formula may contain a deleted range, an invalid row or column number, or a broken external workbook reference. Select the formula cell and inspect the formula bar or use the error warning icon to choose Trace Error.
How do I find an unwanted reference to another Excel workbook?
Select the affected formula and look in the formula bar for a reference in square brackets, such as [Workbook.xlsx]. Replace that reference with the correct range in the current workbook, then press Enter.




