If statement Exact match on a range of data

[smanas]

Hello I'm trying to creating a filter using an exact match please advise the correct if statement to use

If(match(ABCD,('A1','A2','A3','A4',),'Yes','No')

Kindly correct my code thank you

[Rockstar7]

@smanas  need to provide brackets correctly . try below one

If(match(ABCD, 'A1','A2','A3','A4'), 'Yes', 'No')