Then the formula is not finding matches. There is something different about the value in A2 and the cell it should match in the bad customer list. Look for hidden spaces, try TRIM(A2) instead of just A2 in that formula.

The formula should not be giving 0 answers anyway, it's a TRUE/FALSE formula.

If you continue to have problems, click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.