lookup

Finds and replaces data with a value you specify. It is preferable to use the case construct.

lookup ( name ) in ( value1 --> value2 ) default ( expression )

lookup ( [Country]) in ( 'Canada'--> ( [List Price] * 0.60), 
'Australia'--> ( [List Price] * 0.80 ) ) default ( [List Price] )