Conditional Column Setup: Handle Error in Lookup Function

I'm trying to set up a column so that it only runs if another column dooes not have data AND that column did not return an error. I'm using this formula for the conditional: !{{Lookup Contact by LinkedIn}} That correctly returns true if the {{Lookup Contact by LinkedIn}} column did not return results, but it also returns true if the reference column returned an error.