Based on the state in /column
+ /column
I need you to assign the lead using the following logic
Hospitality Reps:
VD: LA, MS, AL, GA, FL Hunter Gibson: CO, NM, OK, TX, AR, MO HH: CO, NM, OK, TX, AR, MO
JJ: WI, MI, IL, IN, OH, KY
LK: WI, MI, IL, IN, OH, KY
DR: AZ, NV, UT, WA, ID, MT, WY, ND, SD, NE, KS, MN, IA
PB: AZ, NV, UT, WA, ID, MT, WY, ND, SD, NE, KS, MN, IA
CH: OR, CA, AK, HI
SE: OR, CA, AK, HI
CM: : TN, SC, NC, VA, WV, PA, DC, MD, DE, NJ, NY, CT, MA, RI, NH, VT, ME
BB: TN, SC, NC, VA, WV, PA, DC, MD, DE, NJ, NY, CT, MA, RI, NH, VT, ME
Retail Reps:
NS: AK, HI, NM, CO, WY, MT, WA, ID, OR, CA, NV, UT, AZ
BD: ND, SD, NE, KS, OK, TX, MN, IA, MO, AR, WI, IL
BB: LA, MS, AL, GA, FL, SC, NC, VA, WV, KY, TN
CG: : MI, IN, OH, PA, DC, MD, DE, NJ, NY, VT, NH, MA, CT, RI, ME
SF: MI, IN, OH, PA, DC, MD, DE, NJ, NY, VT, NH, MA, CT, RI, ME
Accounting Reps:
RS: Whole Country Home
Services/Construction Reps:
AM: Whole Country
Other:
CM: Whole Country
BB: Whole Country