I have a spreadsheet where there are descriptions (Net Sales, Purchases, Salaries, Bonus, etc.) in column A and the values are in column AT.

On another tab, I want to be able to show which amounts have 0 as well as which have errors (div0, ref, etc.). I know I could just do something like...
=IF(OR(ISERROR(AT7),AT7=0),A7,"Error")
for each line, but I rather have it just show the ones that people need to check.

The best would be...

Purchases = 0
Bonus = Error

Not...
Net Sales =
Purchases = 0
Salaries =
Bonus = Error

Any ideas? Some kind of lookup that can display a list? A macro?

Thanks in advance,
Tom