Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')