If statement check

Leith,

Is there a way to display: (error for any non existent standard) comma (industry for defined standard)? This way the user would be notified of the error, but still be able to see if there is an industry available for the company. If not, could you explain how to make is so that it does nothing for the error, and displays the industry for the standards that have been defined, even if they are in the same cell as a non defined standard?