How to Fix #N/A Error in Excel Lookups (IFERROR & XLOOKUP)
When VLOOKUP or XLOOKUP cannot find an exact match in the lookup range, Excel throws an unsightly #N/A error. This breaks downstream calculations and looks unprofessional on executive reports.
Solve it right now
| # | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Code | Price (Fix Here) | Item Code | Unit Price | |
| 2 | SKU-999 | #N/A Fixed | SKU-101 | 45 | |
| 3 | SKU-102 | 80 | |||
| 4 | SKU-103 | 120 | |||
| 5 | |||||
| 6 | |||||
| 7 |
Deskademy simulates real office software with instant grading, hints, and certified CV credentials.
Step-by-step instructions
Identify the Missing Match
Determine which lookup value is returning #N/A in your table.
Wrap in IFERROR or use XLOOKUP Fallback
Wrap your formula: =IFERROR(VLOOKUP(A2, D:E, 2, FALSE), "Not Found") or use XLOOKUP's 4th parameter: =XLOOKUP(A2, D:D, E:E, "Not Found").
Verify Clean Display
Press Enter. Missing entries cleanly display your default fallback text instead of the #N/A error.
Master Excel in the Deskademy Gym
Drill 10+ repeated variations on this exact topic until it becomes second nature for your next job interview.