VLOOKUP fix examplecopy-ready
Inputmissing exact match
=VLOOKUP(A2, Products!A:C, 3)
Outputformula
=IFERROR(VLOOKUP(A2, Products!A:C, 3, FALSE), "")
VLOOKUP formula fixer
Fix VLOOKUP formulas.
Make VLOOKUP return the right match instead of #N/A or the wrong row.
Why does VLOOKUP break?
VLOOKUP usually breaks because the lookup value is missing, exact match mode is omitted, the return column number is wrong, or the lookup column is not first.
1
Check lookup value
Confirm A2 matches values in the first column of the lookup range.
2
Use exact match
Use FALSE or 0 when matching IDs, SKUs, emails, or names.
3
Handle missing rows
Wrap with IFERROR if missing matches should return blank.
Example
Best starter VLOOKUP pattern
For IDs and SKUs, start with IFERROR plus exact match: =IFERROR(VLOOKUP(A2, Products!A:C, 3, FALSE), "").
Use this when VLOOKUP returns #N/A, the wrong value, or breaks after rows change.
The lookup column must be the first column in the selected range.
If you need lookup-left behavior, XLOOKUP or INDEX/MATCH may fit better than VLOOKUP.