From Dev.to
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. FILTER uses #N/A for two different...