Re: More mapping advice needed

You made it too complicated.  Here:

Function Lookup (parameter_in)

 Select case parameter_in
    case "Y"

       Lookup = "Approved"

    case "N"

       Lookup = "Denied"

    case "U"

       Lookup = "Unknown"

    case else

       Lookup = ""

  End Select

End Function
 

This might use less object invocation.

– Weak Architect