---
title: "Discussion on \"FILTER \"No matches are found\" #N/A in Google Sheets: two causes, read the tooltip first\" | Hashnode"
description: "Discussion on \"FILTER \"No matches are found\" #N/A in Google Sheets: two causes, read the tooltip first\". =FILTER(...) comes back as #N/A. The key you wanted might be missing, or it might be sitting right there. Both look like #N/A. The tooltip is what tells them apart.\nWhy it happens\nFILTER uses #N/A for"
url: "https://hashnode.com/posts/filter-no-matches-are-found-n-a-in-google-sheets-two-causes-read-the-tooltip-first/6af530c2c6ace04af82917bf"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first](https://sheeterror.hashnode.dev/filter-no-matches-are-found-n-a-in-google-sheets-two-causes-read-the-tooltip-first?utm_source=hashnode&utm_medium=feed)

\=FILTER(...) comes back as #N/A. The key you wanted might be missing, or it might be sitting right there. Both look like #N/A. The tooltip is what tells them apart. Why it happens FILTER uses #N/A for

6d ago · 3 min read · sheeterror.hashnode.dev  
Read the article

-   [#tutorial](https://hashnode.com/tag/tutorial)
-   [#google-sheets](https://hashnode.com/tag/google-sheets)
-   [#spreadsheets](https://hashnode.com/tag/spreadsheets)
-   [#productivity](https://hashnode.com/tag/productivity)

## Written by

[SheetError](https://hashnode.com/@sheeterror)

@sheeterror

  
[View profile](https://hashnode.com/@sheeterror)

Plain-English fixes for Google Sheets and Excel errors. Guides at sheeterror.com

Plain-English fixes for Google Sheets and Excel errors. Guides at sheeterror.com

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
