Try =$C4=isna(vlookup($C4,Supply,1,False))

Duke

"GregR" wrote:

I have a worksheet that has many columns, one of which is a model
number. I have conditional formated this column, so that if the model
number exists in a table(Supply) on another sheet, it colors the cell.
I am using the following formula in CF to get that result:

=$C4=vlookup($C4,Supply,1,False) and it works as designed. What I want
is the opposite effect, if the item is not found in the Supply table, I
want the CF to apply. I have tried:

=$C4<vlookup($C4,Supply,1,False)as well as many other combos to no
avail. What is the formula. TIA

Greg