VLOOKUP not working or returning #N/A: 6 common causes

The value is clearly there, yet VLOOKUP says #N/A. These are the usual reasons.

The message you see
VLOOKUP returns #N/A
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Compare two lists instead →

Why this happens

How to fix it

  1. 1Always use exact match: =VLOOKUP(A2,$D$2:$F$500,2,FALSE).
  2. 2Trim spaces and make both columns the same type.
  3. 3Consider XLOOKUP or INDEX/MATCH when the key isn't the first column.
  4. 4Wrap in IFNA() only after the real mismatch is fixed.

Related guides

Still stuck? Ask SheetFix Support