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.

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.

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.



