How to solve #N/A error and record not found in Excel?
Braxorn · Last updated 2026-11-22 · English
#N/A mostly indicates that the searched value cannot be found. The record may actually disappear; also two seemingly identical values may not match due to different data type or extra space.
What can you do?
- Check that the searched code actually exists in the source table.
- Compare the text/number type, leading zeros and invisible spaces on both sides.
- Examine the choice of exact or approximate match with the search range; IDs such as product codes usually require an exact match.
A small example
It is not always correct to assume that the code 00127 in the order list is the same as the numeric 127 in the source table. First determine the meaning of the code system and standardize the two tables accordingly.
What to watch for
Do not automatically match the missing record with a zero price. A clear "Record not found" result is more informative than an incorrect amount.
Check the result
Check the search with three codes present, absent, and similar looking.
Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.
Microsoft source (English)
Review your own workbook
You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.
Review your file