use wildmatch on multiple rows in a column

[hillarynyawate]

How can i use wildmatch on multiple rows in a column

=if(wildmatch(column_name,'*Medic*'),'MEDICATION')
=if(wildmatch(column_name,'*Consult*'),'CONSULTATION')
=if(wildmatch(column_name'*Proc*'),'PROCEDURE')

[stevejoyce]

Like this you're looking for?

=if(wildmatch(column_name,'*Medic*'),'MEDICATION'
 ,if(wildmatch(column_name,'*Consult*'),'CONSULTATION'
 ,if(wildmatch(column_name,'*Proc*'),'PROCEDURE')))

[HugoRomeira_PT · Accepted solution]

Hello,

You can achieve this using the Pick() and Wildmatch() functions.

Try the following: 

=Pick(wildmatch(column_name,'*Medic*','*Consult*','*Proc*'),'MEDICATION','CONSULTATION','PROCEDURE')

Hope it helps!

[hillarynyawate]

@HugoRomeira_PT  Thanks man, it worked!