I'm building an audit tool that has a checklist in one worksheet and the
report in another worksheet. The checklist worksheet has questions and a
YES/NO/NA column. When the question is answered NO, it autopopulates the
corresponding recommendation in the report worksheet. I have a "reference"
column that contains links to best practices, etc. in both worksheets.

When I don't have a reference to cite in the checklist worksheet, and the
answer to the question is "NO" (which causes the automatic population of the
recommendation in the report worksheet), the reference column has a "0" in
it.

WHAT CAN I DO TO STOP THE "0" FROM APPEARING IN THE REFERENCE COLUMN IN THE
REPORT WORKSHEET?

Following are examples of the formulas I'm currently using for the two
columns (recommendation and reference).

Recommendation: =IF(Checklist!C201="NO",Checklist!D201,"")
Reference: =IF(Checklist!C201="NO",Checklist!E201,"")

Many thanks.
--
Bill