mixmatch function

[Anonymous]

Hi

The statement below returns nothing, the BRANCH has upper and lower case data items.Thanks

IF(MixMatch(BRANCH,'DOME','MAKOLA' ,'AVENOR','MUUS'),'GREATER ACCRA',
IF(BRANCH='SWEDRU','CENTRAL',

IF(BRANCH ='KUMASI','ASHANTI',Null()))) as Region,

[Miguel_Angel_Baeyens]

Hi,

Check attached just in case, but that expression is actually working.

Regards.

Miguel