Formula guide · Excel and Google Sheets · Updated May 13, 2026
FILTER No Matches Found
Fix FILTER formulas that return no matches or show an error when nothing meets the condition.
Quick Answer
Wrap FILTER in IFERROR when an empty result should show a friendly message instead of an error.
Copyable Formula
=IFERROR(FILTER(A2:D100,C2:C100="Paid"),"No matches")Syntax
=IFERROR(FILTER(range, condition), "No matches")Excel and Google Sheets
Worked Example
| Symptom | Fix |
|---|---|
| No rows match | Use IFERROR fallback |
| Wrong condition | Check spelling and data type |
| Spill blocked | Clear output range |
Result: When no row matches, the formula returns No matches instead of a raw error.
Steps
- Confirm that at least one row should match the condition.
- Check text spelling, spaces, and number formats.
- Wrap the FILTER formula in IFERROR for a clean empty state.
Common Mistakes
- Using IFERROR to hide a condition that is written incorrectly.
- Forgetting that FILTER also fails when the spill range is blocked.
- Returning a blank fallback when users need to know the filter found nothing.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.