Handle missing SKUs in a lookup (IFERROR)
Customer service forwarded an order list, and one of the SKUs was discontinued — it is not in the price list anymore, so a plain lookup would blow up with an error in the middle of your report. Fill the Unit price cells F2:F4 so every order row either shows the matched price or the text Not found.
Your solution should use cell references so it updates automatically when Test Case input values change.
Notes
IFERROR(value, value_if_error) wraps any formula and replaces its errors (#N/A, #REF!, #DIV/0!) with a fallback. Scoping note: it also hides genuine mistakes like a typo'd range, so use it at the edges of a report, not while debugging.
Function guide
FAQ
How do I hide #N/A from VLOOKUP?
Wrap it: =IFERROR(VLOOKUP(E2, A2:C6, 3, FALSE), "Not found"). When the lookup misses, IFERROR returns the fallback text instead of the error.
IFERROR or IFNA — which should I use?
IFNA only catches #N/A (missing lookup values) and still surfaces other errors. IFERROR silences every error, which can mask real mistakes. For lookup fallbacks, IFNA is the more precise tool.
Does IFERROR slow down large sheets?
Marginally — it evaluates the inner formula and checks the result. On report-sized ranges it is negligible; on whole-column array formulas it adds up.