Lookups against many values or repeated names fail
Lookups against lists of many values, tags, or repeated names return wrong matches, errors, or no rows.
Tier I · Proven The best-established problems.
6 public reports · first reported 21 May 2020 · last reported 23 June 2025
What's going wrong
People matching items against a list of many values report that substring matches pull in the wrong items, that array criteria from a list of invoice numbers or plays return only the first match, and that index and match formulas across sheets produce errors.
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 6 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.