2 Replies Latest reply: Jul 13, 2011 12:40 PM by At titude RSS

    Display hardcoded value instead of displaying null when the match is not found in lookup

      Hi All

       

      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...

       

      Thanks

       

      Attitude