Home / Error Lookup / #N/A

#N/A

Excel #N/A Error Applies to: Windows 7, Windows 10, Windows 11

What it means

A lookup formula (VLOOKUP, MATCH, XLOOKUP, INDEX/MATCH) couldn't find a matching value.

Also seen as: #N/A

Quick fix steps

  1. Check for typos or extra spaces in either the lookup value or the source range — use TRIM() to strip hidden spaces.
  2. Confirm both sides of the lookup are the same data type — a number stored as text won't match a real number.
  3. For VLOOKUP specifically, confirm the column index number is correct and that you're not accidentally searching a range that starts after the lookup column.
For the full step-by-step walkthrough, see Understanding Excel Formula Errors (#REF!, #VALUE!, and More).

Frequently Asked Questions

Does #N/A mean the data doesn't exist anywhere?
It means your lookup formula couldn't find a match in the range you specified — the data might exist elsewhere in your spreadsheet under a slightly different spelling, format, or in a range the formula isn't actually searching.
Is #N/A worse than other formula errors?
No — it's actually one of the more informative ones, since it specifically tells you a lookup failed to find a match, which narrows down what to check compared to a more generic error.

Other error codes

#REF! — #REF! Error

A formula is pointing to a cell that no longer exists — usually because a row, column, or sheet it referenced was deleted.

#VALUE! — #VALUE! Error

The formula received the wrong type of data — commonly text where it expected a number.

#DIV/0! — #DIV/0! Error

The formula is dividing by zero or by an empty cell.

#NAME? — #NAME? Error

Excel doesn't recognize text used in the formula — most often a misspelled function name or a missing quotation mark.