Why Excel Adds an @ Symbol to INDEX MATCH Formulas and How to Fix It
Question details
The user needs to know why Excel automatically adds the @ symbol to INDEX MATCH formulas and how to stop Jet Reports from re-adding it after each refresh.

- Product
- Microsoft Excel with Jet Reports
- Device & OS
- not provided
- Scenario
- Maintaining or refreshing an Excel workbook where INDEX MATCH formulas are generated by Jet Reports.
- Observed behavior
- Excel adds @ symbols to range references, causing implicit intersection behavior and potentially unexpected formula results.
Before editing formulas, confirm whether the workbook is connected to Jet Reports and whether the @ symbols appear only after a report refresh.
Remove the @ symbol from affected INDEX MATCH formulas manually
Use this for an immediate fix when only a small number of formulas need to be corrected and a Jet Reports refresh is not imminent.
Click the cell that contains the INDEX MATCH formula showing the @ symbol.
Click inside the Formula Bar or press F2 to open the formula for editing.
Remove the @ symbol only from the range reference, for example change @A:A to A:A.
Press Enter and verify that the formula now returns the expected value.
Update the Jet Reports formula generation or contact Jet Reports support
Use this for a permanent fix when Jet Reports refresh keeps adding @ symbols to newly generated formula rows.
Switch to WPS Spreadsheets for a Familiar Formula Experience Without Jet Reports Conflicts
WPS Office is a free, lightweight Microsoft Office alternative that opens Excel workbooks with full format compatibility, so you can view and edit INDEX MATCH formulas in a familiar ribbon interface without relying on Excel-only add-ins such as Jet Reports.
- 1. Download WPS Office: Go to the official WPS Office website and download the free installer for your device.
- 2. Open the Excel workbook: Launch WPS Spreadsheets and open the .xlsx workbook that contains the INDEX MATCH formulas.
- 3. Review or edit the formula: Select the formula cell, click in the Formula Bar, and review or edit the INDEX MATCH formula without the Jet Reports refresh workflow.

Frequently Asked Questions
Why does Excel insert an @ symbol into my INDEX MATCH formula?
Excel adds the @ symbol as the implicit intersection operator when a formula supplies a range where a single value is expected. It tells Excel to return the value from the same row or column as the formula.
Does the @ symbol mean my INDEX MATCH formula is broken?
Not by itself. The @ symbol changes how Excel resolves the range. If the formula returns incorrect results after a Jet Reports refresh, the issue is usually the older formula-generation behavior rather than a standard formula error.
Can I permanently stop Jet Reports from adding @ symbols to INDEX MATCH formulas?
Manual removal works only until the next refresh. A permanent fix requires updating the Jet Reports report template or formula-generation logic, or contacting Jet Reports support for a compatibility update.
Do I need to press Ctrl+Shift+Enter to fix the @ symbol?
Not necessarily. The @ symbol is related to implicit intersection, not a missing legacy array formula entry. Check whether the formula generator is supplying a range where Excel expects a single value.
Can WPS Spreadsheets open an Excel workbook with these INDEX MATCH formulas?
Yes. WPS Spreadsheets supports .xlsx, .xls, and .csv files and can open and edit INDEX MATCH formulas, but Jet Reports integration must still be handled in its own environment.





