FinanceTier 418 minintermediate

Flag a Cost Centre Code That Isn't in the Chart of Accounts

Show a readable flag for a retired or mistyped cost centre code instead of letting #N/A through.

What you will learn

• Wrap a lookup in IFNA to catch specifically the not-found case
• Explain why IFERROR would also hide a genuine formula mistake, not just a missing code
• Count how many transactions reference a code the chart of accounts does not have

Excel skills

IFNA, VLOOKUP, XLOOKUP · Lookups

The task

Every transaction quotes a cost centre code that should exist on the Chart tab. A couple of these codes are retired or mistyped and don't appear there at all. In C2, look up each code's division name - and instead of letting a not-found lookup show #N/A, show "Unknown cost centre". In a cell of your choice, count how many transactions reference a code that isn't on the chart.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free