Match instead of if condition

[onkarkulkarni]

Hello there,

I am trying to use 'Match' instead of 'if' . I have Region and country column in my data.

Condition is :

if Region in ('Asia','Africa',Europe') and Country in ('India','China') then 'Asia Pacific'

Could you please suggest how can I use 'match here ?

I tried with : =if (match([Region],'Asia','Africa',Europe and (match([Country],'India','China')), 'Asia Pacific'))     Its not working

Thanks in advance.

[tresesco · Accepted solution]

Try like:

=if (match([Region],'Asia','Africa','Europe') and match([Country],'India','China'), 'Asia Pacific')

Note the bracket corrections.

[onkarkulkarni]

Thanks Tresesco .. It was silly mistake.. Its working fine