I have an automatic lookup table working great, however, when a value isn't in my lookup table, I was hoping to have a default result of "not found". Any idea how I would tackle that?
Go to Settings -> Lookups -> Lookup Definitions
Click on your lookup definition, check the Advanced options checkbox
In the Default matches text box add not found, then save.