Lookups and counts on imported cells return zero or errors
Lookup and count formulas that read imported cells return zero, no match, or parse errors.
Tier II · Emerging Problems that are still building up.
4 public reports · first reported 6 June 2022 · last reported 26 June 2026
What's going wrong
People who use COUNTIF, MATCH, VLOOKUP or two-criteria lookups over imported values find the function returns zero, reports no match, or throws a parse error, even when the values appear on screen.
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 4 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.