How about just hidding the error response by conditionally formatting the
text white?

I run into this often, and have found this solution really good (most of the
time).

Formula for the conditional format is like:

=ISERROR(A2)

Then just set the text color to white in the "format" area.