The audit sheet has a missing item lookup in one row and a per-order average with zero orders in another. Both are errors, but the person fixing each row needs a different next step.

Add a separate action column

Leave the result in A2 and put the audit label in B2:

=IF(ISERROR(A2),IF(ERROR.TYPE(A2)=7,"Check lookup",IF(ERROR.TYPE(A2)=2,"Check denominator","Review error")),"OK")

ERROR.TYPE returns 7 for #N/A and 2 for #DIV/0!. ISERROR separates ordinary values before the classification runs.

A failed lookup shows #N/A and an average formula with a zero denominator shows #DIV/0!.

Illustrated audit inputs. Keep the original errors visible in the formula column.

Test two errors and a valid result

For #N/A, confirm Check lookup. Trace the missing ID or a different cause of #N/A back to its formula. For #DIV/0!, confirm Check denominator and inspect the divisor. An ordinary result like 4 should say OK. Other errors should remain visible with Review error in the audit column.

ERROR.TYPE 7 routes to Check lookup, 2 routes to Check denominator and other errors route to Review error.

Illustrated routing rules. Test an ordinary number as well.

The labels route a review. Check the underlying formula and repair its source instead of using the label as the calculated value.

Microsoft’s Excel function reference