Spreadsheet: 261734d1377802571-help-need-to-make-a-2-different-dropdowns-dependant-upon-1-copy-of-excelhelp
Sheet: DropDown Formulas

ApptType | TC | TCFIX | SRO | SROFIX
TC | 1st Repeat TC | Add In House Amp | 4thPassSpecProj | 125’HandSpade
SRO | 2nd Repeat TC | [NAME] Up | ActivatePlant | 125’HandSpade 1DW
 | 3rd Repeat TC | BoxAuthorizationNeed | Audit 2ndPass | 125’HandSpade 1DW3’SW
 | 4th Repeat TC | CableData Err | Audit 3rdPass | 125’HandSpade 2DW
 | 5th Repeat TC | Cablevision Related | Audit [NAME] | 125’HandSpade 2DW3’SW
 | 6th Repeat TC | CP Business T/C | Audit Primary | 125’HandSpade3’ SdWk
 | 7th Repeat TC | Cust Ed AV input | AuditBBTrap-2ndPass | 25’HandSpade
 | 8th Repeat TC | [NAME] email | AuditBBTrap-Primary | 50’HandSpade
 | 9th or > Repeat TC | [NAME] | AuditProj3Pas | [NAME] Cp
 | Agreed to $39.95 Fee | [NAME] | AuditReferral | AuditCP Dx
 | Agreed to $46.95 Fee | Cust Ed PHN Feature | AuditSpecial Project | AuditCronic
 | All Equipment | [NAME] | AuditValidate | AuditInstTrap
 | All Serv OK|A-Outlts | [NAME] | AuditVideoTrp Primary | AuditVerfActv
 | All Serv Out|A-Otlts | Cust Ed Video | AuditVideoTrp2ndPass | AuditVerfTrap
 | Audio Problem | CustNetworkData | AuditVideoTrp3rd Pass | AuditVerifyDx
 | Boost+ or Ultra | CustNetworkVoice | BBTrapInst | BalFeeder
 | [NAME] SLA | Customer Education | BBTrapRemv | BalReturn
 | Bz-PHN 1-4 Svc Only | [NAME] | BizMonitor48 | [NAME]
 | Bz-PHN 5 or More | DefectCustEqp/Sftwr | BizMontiorRef4hr | Business QC CP
 | Cable Modem | Defective CPE Equip. | Business QCs | CD Inaccurate
 | CableCARD | In Replace [NAME] | Chanel Probm | CD-NT Disco
 | Chg Remote Insist TR | [NAME] | Check Battery Backup | ChFilterRepl
 | ChnlMissing/NotAuth | InsideCoaxRepair | Chk Arris 512 BB | CLI Ingress In
 | Defective Cust Equip | Issue Not Observed | Chng/Bad Tap | CLI IngressOut
 | Diagnosis/Check Grnd | Issue Observed | CommInstallUG | CLI Repair Sys
 | [NAME] | Loose Fitting | Disc If Active | ComplimentReceived
 | DVR Plus Prob | Modem/BoxReset | Disc In Error | CustComplaintResolvd
 | Education Router | No Trouble Found. | DisPriorTkRol | DieFS Related
 | Gateway Device | Not Home/Outside Fix | DropOffEquip | DiscoComplt
 | HM-Swap4Arris | NoTempRefUG | DynModChngUTT | DmgCompComple
 | HSD |All Out|A-Otlts | Out of Spec @ Outlet | [NAME] | DX AlreadyCP
 | HSD |Intermt|1-Otlts | Out of Spec @ Tap | FldSvcAptDrop | ELT 1 Tap
 | HSD |Intermt|2+Otlts | Out of spec bad equp | FS CLI Sgn Lk | ELT 2 Taps
 | HSD |Intermt|A-Otlts | Out of [NAME] | FS DisconnectQC | [NAME] [NAME]
 | HSD |Persist|1-Otlts | Out of Spec Grnd Blk | FSPicUpEquip | ELT No Access
 | HSD |Persist|2+Otlts | OutageRelatedNTF | GoBack-FSUse | ELT TimingOffsetExc
 | HSD |Persist|A-Otlts | OutOfSpecCustEquip | Hgh Fwrd Levl | ELTChk1Drop
 | HSD Connect Issue | Outside Bad Neutral | HighRetLevel | ELTChkMultDrp
 | Indoor [NAME] Issue | Outside coax repair | Id Apt Lines | EqSroComplt
 | Interactive Ch Prob | Outside Disc Error | Indoor [NAME] | FS Dx NotDone
 | Known Outage/Defect | Outside Repl Gnd Blk | Ingress | Go Back CP
 | LowLevelsForwardPath | Outside Replace Drop | IngressMitBoost | Good At Tap
 | Monitor House Issue | Outside Trap Issue | IngressMitOOL | GoodAtGrndBlk
 | NetwrkRtr | Preventative Maint | InstalGround | IncDisReseach
 | No Equipment | [NAME] | InstRepPedLock | IncFr2FSSupv
 | No Picture | RebootInWiFiAP | Intermittent Data | IngressComp
 | NoInbound DID | ReferAptDrop | Intermittent Video | InsrtChReset
 | Packet Loss | Referral-FS Super | Intermittent Voice | Installed BattBackup
 | Per Bisc-Swap Modem | RefNWMRemedy | Low [NAME] | InterIngress
 | PHN |All Out|A-Otlts | [NAME] | LowRetLevel | Intermit NBS
 | PHN |Intermt|1-Otlts | RefOSP48Hrs | [NAME] | IntPrbPenDat
 | PHN |Intermt|2+Otlts | Replace Drop w/RG11 | No Signal | IntPrbPendOV
 | PHN |Intermt|A-Otlts | Replaced CableCARD | NonStdWorkNd | IntPrbPenVid
 | PHN |Persist|1-Otlts | Replaced Gateway | OSP CLI SigLk | [NAME]
 | PHN |Persist|2+Otlts | Replaced Modem | OSP [NAME] | ModulatorRep
 | PHN |Persist|A-Otlts | [NAME] | OV4BBzPreSurvey | NoContactSent
 | PHN Drop Call | Replaced [NAME] | OV4BVerifyAlarm | NodeSplitComp
 | PHN Jack/Wiring | ReplB2BUA | OV4BVerPhone Switch | NTF-AP OK
 | PHN No Dial Tone | [NAME] | OV4BVerServcbleAddr | Nu SideHouse
 | PHN No Inbound | ReplHomeRouter | PickUpEquip | NUM Closed
 | PHN No Outbound | [NAME] | PndNodeSplitBo | NUM OpenNoSec
 | PHN Transmission | ReplWith3.0Modem | PndNodeSplitOOL | NUM OpenSec
 | PHN-Vendor Time | RepStcIPRter | PnPCkSignal&Grnd | NUT NotTerm
 | Pixilation | [NAME] | PnPConnectDrop | NUT PortTerm
 | Refused troubleshoot | [NAME] | PoorPicQualty | OV4B Customer Cancel
 | Remote Problem | RplBxHDMIport | PowerSupplyUTT | OV4B Ready 4 Install
 | ReservedStormDmg | RplConnOrJumperWire | [NAME] | [NAME]
 | Return Issue | RplTuningAdapter | Ref2BizSupvr | OV4B Require UG Drop
 | RF Signal Issue | SDHD Box TV Mismatch | Refer OSP48Hr | OV4BReqLndLRD Permit
 | Router for Static IP | Self Install Rescue | ReferFldSvcSv | OVBzPreSrvyCP
 | SA DVR Issue | Storm Damage repair | RefInstCntDmg | Pend Rem-ISP
 | SA HD | Telco/Power DropDown | RefOV4B2OSP48 | Pending SRO
 | SA HD DVR | Vandalism | RefOV4B2OSP4h | PendRem-BISC
 | SA SD |  | RepInstUGDrop | PendRem-RFDN
 | SA SD DVR |  | Residential QCs | [NAME]
 | [NAME] |  | ResiMonitorRef24 | PnPConnectDrp
 | [NAME] |  | ResiMonitorRef48 | Pole xfer CP
 | Self-InstRescue |  | RetFiltInstal | PU SideHouse
 | Single Channel PQ |  | RpeatMonitorRef48 | PUM Closed
 | SIP-B2BUA |  | RpeatMontiorRef24 | PUM OpenNoSec
 | Slow Internet Speed |  | RplInstAerDrp | PUM OpenSec
 | STB Boot Issue |  | SameDayRefOSP | PUT NotTerm
 | [NAME] |  | Survey ReloO/U | PUT PortTerm
 | Switched Video |  | SurveyPoleXfer | QC Complete
 | [NAME] |  | SurvyLkBx/Ped | ReasnNoClasfd
 | TV | All Out|A-Otlts |  | Unable to DIE | RefCLINHNoAcc
 | TV | Intermt|1-Otlts |  | VidInstTrap | Refer FS-UG
 | TV | Intermt|2+Otlts |  | VidRemvTrap | Refer2FldSvc
 | TV | Intermt|A-Otlts |  | VolDisc No Trucked | Refer2OSP
 | TV | Persist|1-Otlts |  | [NAME] | Refer2OV Ops
 | TV | Persist|2+Otlts |  |  | RefFSBizSupv
 | TV | Persist|A-Otlts |  |  | RefOSPOvrnit
 | Verify Enhncd Wiring |  |  | ReloCPAer-UG
 | [NAME] |  |  | [NAME]
 |  |  |  | RepILEHouse
 |  |  |  | Repl Antenna [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Repl Ret Amp
 |  |  |  | Repl Spl/Plate
 |  |  |  | Repl Tap/Plate
 |  |  |  | Replace AP
 |  |  |  | Replace Fuse
 |  |  |  | ReplBrdgMod
 |  |  |  | ReplDCPwrPck
 |  |  |  | ReplModule
 |  |  |  | ReplNodeOpt
 |  |  |  | [NAME]
 |  |  |  | ReplPwrInsert
 |  |  |  | ReplStaMonMod
 |  |  |  | ReplTrkHouse
 |  |  |  | ReplTrunkMod
 |  |  |  | [NAME]
 |  |  |  | RetrnPathCert
 |  |  |  | RplInstOHDrpCP
 |  |  |  | [NAME]
 |  |  |  | SpliceFibrCut
 |  |  |  | SplicePlantCable
 |  |  |  | SurvyComp2Ins
 |  |  |  | SystemSecFail
 |  |  |  | TightenSeizeScw
 |  |  |  | Tone & Tag
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Trap Removed
 |  |  |  | [NAME]
 |  |  |  | Verified Replaced BB
 |  |  |  | VerifiedNoReplaceBB
 |  |  |  | VerOKCustContact
 |  |  |  | WiFiRadioRebot
 |  |  |  | WifiRadioRep