🎯 Targeted Error Handler

Goal: Handle missing lookups gracefully.
IFNA catches #N/A (Not Found) but ignores other errors (like #DIV/0!), alerting you to calculation issues.

Ready...

💻 Formula Structure

=IFNA(value, value_if_na)
  • 1. Value: The formula to check (usually a VLOOKUP).
  • 2. If N/A: What to display if the item isn't found.
-- Catch Missing Items, Ignore Real Errors
=IFNA( VLOOKUP(...), "Not Found" )
Final Result:
-
🥅

⚠️ Why use IFNA vs IFERROR?

✅ Precision
Use IFNA when you expect data to be missing.
🚫 Safety
Use IFERROR only if you want to hide crashes (like #REF!). IFNA lets crashes through so you can fix them.