Set value instead of [Not Found]

Is it possible to set a default value if the value is not found,

In my specific case i need NULL instead of [Not Found] (This spans over multiple columns so making a whole bunch of if statements isn’t gonna do the trick)