VLOOKUP returns #N/A — how to fix it

What you see

• VLOOKUP shows #N/A
• Other rows work but some do not

Common causes

• Exact match not found in the first column of the table
• FALSE vs TRUE match type used incorrectly

How to fix it

1. Sort or scan the lookup column for typos
2. Use FALSE for exact match in most cases
3. Consider XLOOKUP or INDEX/MATCH for more flexibility

Example formula

=VLOOKUP(A2,Products!A:C,3,FALSE)