Conditional Format based on VLookUp success

I'm going in circles.

Two sheets. The second has something of a directory organized into a table ("tblDirectory") with vendor names in a Column.

On the first sheet, in a column, the user (me) types in the name of the vendor.

I want the cell to show up with a changed background color if the name of the vendor is not found in the second sheet.

The formula I used is

Please Login or Register  to view this content.

I thought that if it evaluated to "True" then the search term was not found and the cell would be conditionally formatted, but so far nothing.

The extract from the same formula of strictly the VLookUp statement works perfectly in the next column adjacent to the column I wish to run the conditional format, in that it finds the target (the name of the vendor) when it is found (If the vendor name is not found, an IFERROR shows "Not Found", but I wish to eliminate this extra column in favor of conditional formatting).

Thoughts?

THose quotation marks get placed around the formula by Excel!

I will do some tinkering and be back with the results, I appreciate the input.

Thanks etaf - apparently Conditional Formatting pukes with table references. I altered [@Vendor] to the cell reference ("AS3") and tblDirectory to tab and column reference (Directory!$A:$A) and all works fine. Ought to be a warning flag "DO NOT use table references!" Thanks for putting me on the right track-