Spreadsheet: 81104d1281372177-layered-vlookup-with-validation-testcodes
Sheet: Sheet1

Major | Class | Minor | Sub Code
AL-Garage Liab | AG | AG NOC | X |  | Major | Class | Minor | Sub Code
[NAME] | AR | AR NOC | X |  | AL-Private Pass
AL-Leasing/Rental | AU | AU Leasing/Rental LT | L
 |  | AU Leasing/Rental ST | S
 |  | AU NOC | X
AL-LH Truck | AT | AT LH Trk - All Trkrs | T
 |  | AT LH Trk - Flat Bed | F
 |  | AT NOC | X
[NAME] | AC | AC Construction | C
 |  | AC Mixers/Sand & Gravel | M
 |  | AC Retail local delivery | R
 |  | AC Service | S
 |  | AC NOC Misc Comm | X
AL-OTR Buses | AB | AB Commuter/Line | L
 |  | AB OTR Buses Charter | C
 |  | AB School/Church | S
 |  | AB Transit | T
 |  | AB NOC | X
AL-AL NOC | AX | AX Ambulance | M
 |  | AX Ambulette | A
 |  | AX Emerg/Police/Fire | E
 |  | [NAME] | N
 |  | AX NOC | X
AL-Private Pass | AP | AP PP Non-Owned | N
 |  | AP PP Owned | O
 |  | AP Sales Fleet | S
 |  | AP NOC | X
AL-Public Livery | AL | AL Public Livery Black Car | B
 |  | [NAME] | S
 |  | AL Taxi | T
 |  | AL NOC | X
E&O-Accts | EC | EC Accountants | X
E&O-Arch/Eng/Surv | EA | EA Arch/Eng/Surv | X
E&O-Condo | EM | EM Condominium | X
E&O-Data Proc | EE | EE Ins Data Proc | X
E&O-Dir & Offcrs | ED | ED EDP Dir & Offcr | X
E&O-Ins/RE Agts | EI | EI Ins, Real Estate | X
E&O-Lawyers | EL | EL Lawyers NOC | X
E&O-Turnkeys | ET | ET Turnkey NOC | X
E&O-NOC | EX | EX Druggists | D
 |  | EX Police | P
 |  | EX Public Officials | M
 |  | EX Security Guards | S
 |  | EX NOC | X
EL-FELA | LF | LF FELA | X
EL-Maritime | LJ | LJ Maritime | X
EL-NOC | LX | LX NOC | X
GL-Contractors | GC | GC Art Comm/AOS | B
 |  | GC Art Comm/CA,NV,AZ | A
 |  | GC Artisan Res/AOS | T
 |  | GC Artisan Res/CA,NV,AZ | P
 |  | GC Comm Gen/AOS | J
 |  | GC Comm Gen/CA,NV,AZ | G
 |  | GC Conc/Mas/AOS | M
 |  | GC Conc/Mas/CA,NV,AZ | C
 |  | GC Exc/Site Prep/AOS | F
 |  | GC Exc/Site Prep/CA,NV,AZ | E
 |  | GC Hab Gen/AOS | K
 |  | GC Hab Gen/CA,NV,AZ | H
 |  | GC NOC/AOS | Y
 |  | GC NOC/CA,NV,AZ | X
 |  | GC Roofing/AOS | R
 |  | GC Roofing/CA,NV,AZ | D
 |  | GC St & Rd/AOS | S
 |  | GC St & Rd/CA,NV,AZ | N
 |  | GC NOC | X
GL-Crwd-Spc Evts | GE | GE Crowd (Sp Events) | X
GL-Dwlgs & Ldgs | [NAME] | [NAME] | A
 |  | GD Casinos | C
 |  | GD Hotel Motel | H
GL-Gov, Inst & Sch | GG | GG City/Town | T
 |  | GG County | C
 |  | GG Daycare | D
 |  | GG Elementary | E
 |  | GG High School | H
 |  | GG Hosp/Clcs/Nrsg Hms | N
 |  | GG Univ/College | U
 |  | GG NOC | X
GL-Mftg | GM | GM Mfg NOC | X
GL-NOC | GX | GX Ag/Farming | A
 |  | GX Fast Food | F
 |  | GX Rest/Diners | D
 |  | GX Retail | R
 |  | GX Wh/Distr | W
 |  | GX NOC | X
GL-Oil/Chem Ops | GP | [NAME] | W
 |  | GP [NAME] | C
 |  | GP Drilling | D
 |  | GP Manufacturing | M
 |  | GP Lease Non-Ops | N
 |  | GP Lease Ops | O
 |  | GP Refineries | R
 |  | GP Gas Stations | S
 |  | GP NOC | X
GL-Short Line RR | GR | GR Short Line RR | X
GL-Utilities | GU | GU Electrical | E
 |  | GU Gas | G
 |  | GU NOC | X
 |  | GU Water | W
M-Hosp/Clinics | MH | MH Hosps/Clinics | X
MISC-Spec Ev 1st Pty | SE | SE Spec Ev 1st Pty | X
MISC-Farm | SF | SF Farm | X
[NAME],Kidnap | SK | SK Kidnap,[NAME] | X
MISC-Liq Legal | SL | SL Club/Bar | C
 |  | SL Events/Parks | E
 |  | SL Hotel | H
 |  | SL [NAME] | P
 |  | SL Restaurant | R
 |  | SL NOC | X
MISC-Personal | SH | SH Personal | X
MISC-Poll Legal | SP | SP Pollution Legal | X
MISC-Remediation | SR | SR Remed Guar | X
M-Malpractice NOC | MX | MX Malpractice NOC | X
M-Nurses | MR | MR Nurses | X
M-Nursing Homes | MA | MA Nrsg Homes | X
M-Phys, Surg, Dent | MD | [NAME], Surgs, Dnts | X
P/CO-Ag/Foodstuffs | PA | PA Agr/Fdstuffs | X
P/CO-Comp Prts Misc | PM | PM Comp Parts ([NAME]) | X
P/CO-Consumer | PC | PC Elec/Comp/App | E
 |  | PC Foodst | F
 |  | PC Home Goods | H
 |  | PC Sprtg Goods/Rec | S
 |  | PC NOC | X
P/CO-Ind | PI | PI Machinery | M
 |  | PI NOC | X
P/CO-NOC | PX | PX Comm Constr/AOS | C
 |  | PX Comm Constr/CA,NV,AZ | W
 |  | PX Res Constr/AOS | R
 |  | PX Res Constr/CA,NV,AZ | H
 |  | PX NOC | X
P/CO-Oil/Chem | PP | PP Chem Fin Prods | C
 |  | PP Chem Raw Mats | R
 |  | PP Fuel Oil/Gas | F
 |  | PP NOC | X
P/CO-Pharm | PD | PD Drugs/Presc | D
 |  | PD OTC | O
 |  | PD Vits/Herb Supps | V
 |  | PD NOC | X
WC-Aviation | WA | WA California | C
 |  | WA AOS | X
WC-AOS | WX | WX Contractor | C
 |  | WX Energy | E
 |  | WX Farming/Ag | F
 |  | WX Municipality | G
 |  | WX Mfg | M
 |  | WX Nurses/Hosp | N
 |  | WX Office | O
 |  | WX Retail | R
 |  | WX Schools | S
 |  | WX Trucking | T
 |  | WX NOC | X
WC-Mining/Not Ungrd | WM | WM Mining Surface | S
 |  | WM Mining Udgrd | U
 |  | WM-CA Mining Surface | C
 |  | WM-CA Mining Udgrd | A
 |  | WM-NOC | X
WC-USL&H | WU | WU USL&H | X