Newbie "MATCH" syntax

[PWD]

Good afternoon, had some training yesterday but were not given any course notes. I just want to use the MATCH function and it's driving me nuts.

This works,

=If [Patient Group NHS Code Desc] = "Assault" Then "Other" Else [Patient Group NHS Code Desc]

So does this,

=If Left([Patient Group NHS Code Desc];5) = "Other" Then "Other" Else [Patient Group NHS Code Desc]

I just can't get the MATCH syntax right.

=if [Patient Group NHS Code Desc] Match("Other*”) Then "Other" Else [Patient Group NHS Code Desc]

"The function 'If' has missing arguments or closing parenthesis at position 34. (WIS 10061)" And the word MATCH is highlit.

Many thanks,
D€$

 

[PWD]

This seems to work:

=If Match([Patient Group NHS Code Desc];”*Other*) Then "Other" Else [Patient Group NHS Code Desc])

Many thanks,
D€$