Conditional formatting not working in a cell with a colomn formula

Nats.Rudy

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?

SteyJ

Hello, @Nats.Rudy - You can use this formula.

=IFERROR(Vlookup formula here), "")

This will return blank if #NO MATCH occurs.

SteyJ

Hello, @Nats.Rudy - You can use this formula.

=IFERROR(Vlookup formula here), "")

This will return blank if #NO MATCH occurs.