AND/OR in expression

[smanas]

Hello please help me with the below request

Hi, I'm trying to get IDs with certain Zip codes  AND claim codes OR CPT codes 

I tried this but giving me an error

=if(match(ZipCD,'77032','77009','77016','77078','77028','77026','77021','77051','77033','77048')
and
If(match(codes,'01700', '01703', '01712')

or

if(match(CPT,'99145', '92610', '9252', '9223', '9221', '9220', '9254', '9257')

then

'Yes', 'No')

Thank you

[henrikalmen]

You should not have multiple "if". Do it like this:
if( (match(A, '1, '2') AND match(B, '05', '07)) OR match(C, '9', '8'), 'Yes', 'No')