MATCH function

Check if a value matches a list of values

MATCH( lookup_value, value_1, value_2, ... )

Checks if lookup_value is equal to value_1, or value_2, etc. If a match is found, the index of the match is returned, otherwise 0 is returned.

MATCH( @NumberField, 10, 20, 30, 40 )

Returns 1 if @NumberField is 10, 2 if @NumberField is 20, and so on, or 0 if no match is found

IF( MATCH( @NumberField, 10, 20, 30, 40 ) > 0, 1000, 2000)

Returns 1000 if a match is found, 2000 otherwise