Excel & Sheets practice: Error Handling & Data Auditing

Chapter 4 · 2 questions · included in full access

Question 1 · medium
Friendly "not in catalogue"
A customer typed a product name into M1. In K2, return its Price from the Products sheet (column D) — or the text Not in catalogue if the product isn't listed. Wrap the lookup in IFNA.
Solve it in your browser
Question 2 · easy
IFNA or IFERROR?
Why is IFNA(XLOOKUP(...), "Not found") usually better than IFERROR(XLOOKUP(...), "Not found")?
Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

Friendly "not in catalogue"