Outcome #N/A; conditional format

[Tom_Boonstra]

Hi, when I lookup values from a table, I get three different outputs:

- a date when a training is completed.

- '0' when a training is not yet completed.

- '#N/A' when a training is not started.

The '0' I can mask with a conditional format, however the '#N/A' not.

How can I prevent the '#N/A' to be visible in my outcome?

[#2]

@Tom_Boonstra Wrap the formula in IFERROR like this:

=IFERROR ( lookup_formula, "")

[#3]

@Tom_Boonstra 

As variant