I need to assign request Owner ID based upon the contents of an SFDC field - VMA. There are eight possible names in the VMA field and each needs a unique Owner ID value assigned.
I'm looking for suggestions on the the best approach to test each possible name, assign a unique Owner ID when true and my Owner ID when none are true
The logic is:
When VMA = Annie then Owner ID = Annie#. When VMA=Tracey then Owner ID=Tracey#. When VMA=Drew then Owner ID=Drew#, ELSE Owner ID=SysAdmin#
Recommendations?