How to Fix the #N/A Error
Last updated: 2026-09-06
⚡ Quick Answer
The #N/A error indicates that a lookup function cannot find the specified target value within the array.
=IFERROR(XLOOKUP(...), "Not Found")📊 Visual Demo
HOME · INSERT · FORMULAS · DATA
fx =IFERROR(XLOOKUP(...), "Not Found")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 1 | Missing SKU | Inventory List | IFERROR Wrapper | Custom Text |
| 2 | 2 | Exact Match | Parameter set to 0 | XLOOKUP Exact | Controlled Output |
| 3 | 3 | Audit | Clean Display | Verified | Professional View |
🧠 Deep Dive
The #N/A error indicates that a lookup function cannot find the specified target value within the array.
Key Insights
- Every error code tells you the failure class.
- IFERROR should wrap the smallest possible expression.
Common Mistakes
- Blanket-wrapping everything in IFERROR.
- Deleting rows that other formulas reference.
Pro Tips
- Use Go To Special > Errors.
- Fix errors from top-left outward.
FAQ
What does this formula do in plain English?
The #N/A error indicates that a lookup function cannot find the specified target value within the array.
Why is my formula not working?
Blanket-wrapping everything in IFERROR.
Does this work in Google Sheets?
Yes, this syntax is fully compatible with Google Sheets.
What is the most common mistake?
Deleting rows that other formulas reference.
Related Guides
How to Fix the #SPILL! Error in ExcelHow to Use IFERROR in ExcelHow to Fix the #VALUE! ErrorHow to Fix the #REF! ErrorExcel Error Hub
Need Complete Playbooks?
Download our verified manuals covering ERP Cleanup and Modeling.
Explore Playbook Series (From ₹199)