45 seconds Interactive Fix Excel Verified Office Standard

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.

Live browser simulator

Solve it right now

No login or Excel install required
# 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
Want to test your skills across 100+ workplace scenarios?

Deskademy simulates real office software with instant grading, hints, and certified CV credentials.

Start free training academy

Step-by-step instructions

1

Identify the Missing Match

Determine which lookup value is returning #N/A in your table.

2

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").

3

Verify Clean Display

Press Enter. Missing entries cleanly display your default fallback text instead of the #N/A error.

500+ repeated drills

Master Excel in the Deskademy Gym

Drill 10+ repeated variations on this exact topic until it becomes second nature for your next job interview.

Open Excel Practice Gym

Deskademy Assistant

Thinking…