Make missing SKUs degrade to 'Not found' instead of #N/A
The customer-order form lets the team type any SKU. When the code isn't in the catalog the lookup returns #N/A and the row reads broken in the email export. Wrap the lookup so missing items show 'Not found' instead.
Stop the lookup from breaking when an SKU is missing
Practice using VLOOKUP 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.
The customer-order form lets the team type any SKU. When the code isn't in the catalog the lookup returns #N/A and the row looks broken in the email export. Wrap the lookup so missing SKUs show 'Not found' instead.
In F2, return the unit price for the SKU in E2 from the catalog at A2:C9. If the SKU isn't there, return the text 'Not found' instead of #N/A. Lock the catalog range with $ signs so the formula stays anchored when you drag it down the column.
VLOOKUP searches the first column of a table for a value, then returns a value from a column you specify to the right. It's the most common lookup pattern in Excel: 'find this ID, return the matching name'. The fourth argument controls the match type, and almost always wants to be FALSE for exact match.
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Try the formula first. Hints cost CP for a reason.