Conditional formatting not working in a cell with a colomn formula

Hi - I have a colomn that has a vlookup formula and I want it to be blank if there is #NO MATCH. I used conditional formatting to make the background white and the text white - but it is not working.

Here is the formula:

And here is the conditional formatting:

Any ideas if this can be fixed?

Best Answer