Price the wishlist without #N/A breaking the quote
Sales pasted the customer's 12-item wishlist into column F. About half are exact catalog matches; the rest are typos ("Bluetooth Speakr"), products you don't carry ("Power Bank", "Smart Watch"), and close-but-not-exact names ("Headphones" when the catalog says "Wireless Headphones"). One unwrapped lookup and the quote is full of #N/A — wrap it in IFERROR so missing items resolve to 'Item not found' and the rep can scan the column at a glance.
Safe product lookup with error handling
Practice using IFERROR to solve a real small business problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
Sales pasted a customer's wishlist (12 items) into the right-hand mini-table. Half are products from your catalog; the rest are typos, discontinued items, or things the customer made up. Right now an unknown product surfaces a raw #N/A in the Price column and the quote looks broken. Wrap the lookup so missing entries degrade to 'Item not found' instead.
In G2, return the catalog price for the wishlist item in F2. Use INDEX/MATCH (or VLOOKUP) against the catalog, wrap it in IFERROR with 'Item not found' as the fallback, lock the catalog ranges with $ signs, and drag down through G13.
IFERROR is a one-line wrapper that returns a fallback value when a formula errors out. Wrap a VLOOKUP that might miss, a division that might hit zero, or any expression that could throw #N/A, #DIV/0!, #VALUE!, or #REF!, and IFERROR returns your fallback instead.
IFERROR(value, value_if_error)Try the formula first. Hints cost CP for a reason.