zip codes

=IF(M2=OR(90006, 90029, 90038, 90065, 90031, 90011, 90041, 90042),"Becerra", IF(M2=OR(91340, 91331, 91402, 91405, 91605, 91606, 91401, 91607, 91602, 91604, 91423, 91403, 91436, 90604, 91608, 90068), "Berman", IF (M2=OR(91108, 91024, 91007, 91016, 91006, 91011, 91020, 91740, 91750, 91711, 91784, 91773, 91786, 91730, 91701, 91739, 92358, 91737, 91759, 92397), "Dreier", IF(M2=OR(90017, 90014, 90015, 90013, 90021, 90033, 90058, 90255, 90270, 90040, 90201, 90241, 90242, 90706), "Roybal-Allard", IF(M2=OR(90720, 90630, 90623, 90620, 90680, 92833, 90621, 92832, 92835, 92831, 92821, 92806, 92865, 92805, 92867, 92861, 92869, 92866), "Royce", IF(M2=OR(90230, 90232, 90056, 90008, 90043, 90062, 90018, 90019, 90005, 90010, 90020, 90027), "Watson"))))))


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *