Sheets cannot match text against a changing term list
Spreadsheet formulas cannot match a cell's text against a changing list of search terms or values held on another tab.
Tier II · Emerging Problems that are still building up.
8 public reports · first reported 1 June 2016 · last reported 8 May 2024
What's going wrong
Spreadsheet users keep trying to check whether a cell contains any term from a list, or to highlight rows using values kept on another tab.
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 8 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.