Formula Errors

Why Excel Adds an @ Symbol to INDEX MATCH Formulas and How to Fix It

Anum MushtaqAnum Mushtaq Nov 13, 2026 869 views

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.

Why Excel Adds an @ Symbol to INDEX MATCH Formulas
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 you start

Before editing formulas, confirm whether the workbook is connected to Jet Reports and whether the @ symbols appear only after a report refresh.

Solution 1

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.

1
Select the formula cell

Click the cell that contains the INDEX MATCH formula showing the @ symbol.

2
Edit the formula

Click inside the Formula Bar or press F2 to open the formula for editing.

3
Delete the @ symbol

Remove the @ symbol only from the range reference, for example change @A:A to A:A.

4
Confirm the result

Press Enter and verify that the formula now returns the expected value.

Temporary fix: Jet Reports may add the @ symbols again when the report is refreshed, so use this only when you need a quick correction.
Free Microsoft Office alternative

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. 1. Download WPS Office: Go to the official WPS Office website and download the free installer for your device.
  2. 2. Open the Excel workbook: Launch WPS Spreadsheets and open the .xlsx workbook that contains the INDEX MATCH formulas.
  3. 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.
Opens existing Excel INDEX MATCH workbooks with .xlsx, .xls, and .csv format compatibilityFree to download and use with a familiar Office-style interface for easy migrationLightweight performance that runs smoothly even on everyday devicesLets you review and edit formulas without Excel-only Jet Reports refresh interference
QA img-9

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.