Display hardcoded value instead of displaying null when the match is not found in lookup
May I know how to Hardcode the value is the match is not found using "LookUp" function. Usually if the match is found then it returns the matched value, but what if I want to return the hardcoded value if the match is not found instead of displaying null values. Also let me know if the same thing can be done with any other function instead of using lookup.
Hope my question is understandable! If not please let me know...