Imported and cross-sheet ranges return wrong results
Formulas that pull from imported or other-sheet ranges return zero, #N/A or range-size errors instead of the expected values.
Tier I · Proven The best-established problems.
7 public reports · first reported 4 March 2020 · last reported 26 June 2026
What's going wrong
Spreadsheet users who pull data across sheets with IMPORTRANGE, table references or INDEX and MATCH often get zero counts, #N/A errors, or range mismatch messages.
AI-assisted: written with the help of AI from the reports. The idea report has the full summary.
In the idea report
- The full summary.
- The products the 7 reports are about, and how many came each month.
- Related problems.
No business has been found with this problem yet, so the report has no contacts. All sales are final — no refunds. Pricing.