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
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.="ISERROR(VLOOKUP([@Vendor],tblDirectory,1,FALSE))"
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?
Bookmarks