Spreadsheet: 755486d1636911139-i-am-stumped-i-need-a-cell-to-contain-a-drop-down-list-or-display-a-name-depending-data-mass-tracker-2022-final
Sheet: Sheet1

Audit Type | Program | Program | Audit Type | Auditor | Coordinator | Auditor Reference | Auditor Refrence Filtered | Coordinator Conducting Audit? | Coordinator | MONITOR MANAGER COORDINATOR FORMULA Must hit cont shift enter
Annual Program Audit/New Monitor Assignment | 200 - MAINTENANCE IN-SERVICE TRAINING | 200 - MAINTENANCE IN-SERVICE TRAINING | Annual Program Audit/New Monitor Assignment |  |  |  |  | Y
QA Annual | 300 - FUEL SURVEILLANCE | 200 - MAINTENANCE IN-SERVICE TRAINING | QA Annual |  |  |  |  | N
Program Manager Initial | 400 - NAVY OIL ANALYSIS PROGRAM (NOAP) AND OIL CONSUMPTION MONITORING | 200 - MAINTENANCE IN-SERVICE TRAINING | Program Manager Initial |  |  |  |  | Program | Coordinator
Program Manager Annual | 600 - HYDRAULIC CONTAMINATION CONTROL | 200 - MAINTENANCE IN-SERVICE TRAINING | Program Manager Annual |  |  |  |  | 200 - MAINTENANCE IN-SERVICE TRAINING |  | [NAME]))))
Work Center Annual | 800 - QUALITY ASSURANCE | 300 - FUEL SURVEILLANCE | Annual Program Audit/New Monitor Assignment |  |  |  |  | 1300 - TOOL CONTROL
Work Center Supervisor Initial | 900 - MAINTENANCE DEPARTMENT SAFETY PROGRAM | 300 - FUEL SURVEILLANCE | QA Annual |  |  |  |  | 1700 - SUPPORT EQUIPMENT OPERATOR TRAINING AND LICENSING
Work Center Supervisor Annual | 1000 - NAVAL AVIATION MAINTENANCE DISCREPANCY REPORTING PROGRAM | 300 - FUEL SURVEILLANCE | Program Manager Initial |  |  |  |  | 1800 - SUPPORT EQUIPMENT MAINTENANCE |  | MONITOR MANAGER COORDINATOR FORMULA FOR DROP DOWN VALIDATION INSTEAD OF FORMULA IN CELL.  MUST HIT CNTR SHF ENT
Special | 1100 - AIRCRAFT CONFINED SPACE PROGRAM (ACSP) | 300 - FUEL SURVEILLANCE | Program Manager Annual |  |  |  |  | 1900 - TECHNICAL DATA MANAGEMENT
CNAF AMI | 1200 - FOREIGN OBJECT DAMAGE (FOD) PREVENTION | 400 - NAVY OIL ANALYSIS PROGRAM (NOAP) AND OIL CONSUMPTION MONITORING | Annual Program Audit/New Monitor Assignment |  |  |  |  | 2200 - HAZARDOUS MATERIAL CONTROL AND MANAGEMENT
 | 1300 - TOOL CONTROL | 400 - NAVY OIL ANALYSIS PROGRAM (NOAP) AND OIL CONSUMPTION MONITORING | QA Annual |  |  |  |  | 2600 - TECHICAL DIRECTIVE (TD) COMPLIANCE |  | IF(OR(C2="SPECIAL",C2="CNAF AMI"),AUDITOR,IF(AND(D2="Y",C2<>"",B2<>""),INDEX(Sheet1!$F$2:$F$153,MATCH(B2&C2,Sheet1!$C$2:$C$186&Sheet1!$D$2:$D$186,0)),IF(OR(C2="",B2=""),"",INDEX(Sheet1!$E$2:$E$186,MATCH(B2&C2,Sheet1!$C$2:$C$186&Sheet1!$D$2:$D$186,0)))))
 | 1400 - CORROSION PREVENTION AND CONTROL | 400 - NAVY OIL ANALYSIS PROGRAM (NOAP) AND OIL CONSUMPTION MONITORING | Program Manager Initial |  |  |  |  | 2900 - MAINTENANCE CONTROL
 | 1500 - PLANE CAPTAIN QUALIFICATION | 400 - NAVY OIL ANALYSIS PROGRAM (NOAP) AND OIL CONSUMPTION MONITORING | Program Manager Annual |  |  |  |  | 3300 - LOGS AND RECORDS
 | 1600 - EGRESS AND EXPLOSIVE SYSTEMS CHECKOUT | 600 - HYDRAULIC CONTAMINATION CONTROL | Annual Program Audit/New Monitor Assignment |  |  |  |  | 3400 - PHASE MAINTENANCE
 | 1700 - SUPPORT EQUIPMENT OPERATOR TRAINING AND LICENSING | 600 - HYDRAULIC CONTAMINATION CONTROL | QA Annual |  |  |  |  | 3600 - DATA ANALYSIS |  | IF(OR(C2="SPECIAL",C2="CNAF AMI"),AUDITOR,IF(AND(D2="Y",C2<>"",B2<>""),INDEX(Sheet1!$F$2:$F$153,MATCH(B2&C2,Sheet1!$C$2:$C$186&Sheet1!$D$2:$D$186,0)),IF(OR(C2="",B2=""),"",INDEX(Sheet1!$E$2:$E$186,MATCH(B2&C2,Sheet1!$C$2:$C$186&Sheet1!$D$2:$D$186,0)))))
 | 1800 - SUPPORT EQUIPMENT MAINTENANCE | 600 - HYDRAULIC CONTAMINATION CONTROL | Program Manager Initial |  |  |  |  | 3700 - MATERIAL COTROL
 | 1900 - TECHNICAL DATA MANAGEMENT | 600 - HYDRAULIC CONTAMINATION CONTROL | Program Manager Annual
 | 2000 - NAVAL AVIATION METROLOGY AND CALIBRATION | 800 - QUALITY ASSURANCE | Annual Program Audit/New Monitor Assignment
 | 2200 - HAZARDOUS MATERIAL CONTROL AND MANAGEMENT | 800 - QUALITY ASSURANCE | QA Annual
 | 2400 - ELECTROSTATIC DISCHARGE (ESD) PROTECTION / ELECTROMAGNETIC INTERFERENCE (EMI) REPORTING | 800 - QUALITY ASSURANCE | Program Manager Initial
 | 2600 - TECHICAL DIRECTIVE (TD) COMPLIANCE | 800 - QUALITY ASSURANCE | Program Manager Annual
 | 2700 - ELECTRICAL WIRING INTERCONNECT SYSTEM (EWIS) | 900 - MAINTENANCE DEPARTMENT SAFETY PROGRAM | Annual Program Audit/New Monitor Assignment
 | 2800 - MANPOWER MANAGEMENT | 900 - MAINTENANCE DEPARTMENT SAFETY PROGRAM | QA Annual
 | 2900 - MAINTENANCE CONTROL | 900 - MAINTENANCE DEPARTMENT SAFETY PROGRAM | Program Manager Initial
 | 3100 - WEIGHT AND BALANCE | 900 - MAINTENANCE DEPARTMENT SAFETY PROGRAM | Program Manager Annual
 | 3300 - LOGS AND RECORDS | 1000 - NAVAL AVIATION MAINTENANCE DISCREPANCY REPORTING PROGRAM | Annual Program Audit/New Monitor Assignment
 | 3400 - PHASE MAINTENANCE | 1000 - NAVAL AVIATION MAINTENANCE DISCREPANCY REPORTING PROGRAM | QA Annual
 | 3600 - DATA ANALYSIS | 1000 - NAVAL AVIATION MAINTENANCE DISCREPANCY REPORTING PROGRAM | Program Manager Initial
 | 3700 - MATERIAL COTROL | 1000 - NAVAL AVIATION MAINTENANCE DISCREPANCY REPORTING PROGRAM | Program Manager Annual
 | 3800 - AIRCRAFT MAINTENANCE MATERIAL READINESS LIST (AMMRL) | 1100 - AIRCRAFT CONFINED SPACE PROGRAM (ACSP) | Annual Program Audit/New Monitor Assignment
 | 3900 - VIBRATION ANALYSIS | 1100 - AIRCRAFT CONFINED SPACE PROGRAM (ACSP) | QA Annual
 | 4000 - AIRCRAFT ENGINE/APU TURN-UP LICENSING | 1100 - AIRCRAFT CONFINED SPACE PROGRAM (ACSP) | Program Manager Initial
 | 4300 - AERIAL REFUELING STORES (ARS) | 1100 - AIRCRAFT CONFINED SPACE PROGRAM (ACSP) | Program Manager Annual
 | 4500 - BATTERY MAINTENANCE SAFETY | 1200 - FOREIGN OBJECT DAMAGE (FOD) PREVENTION | Annual Program Audit/New Monitor Assignment
 | 4600 - AERCRAFT COMPASS CALIBRATION | 1200 - FOREIGN OBJECT DAMAGE (FOD) PREVENTION | QA Annual
 | 4700 - LASER HAZARD CONTROL | 1200 - FOREIGN OBJECT DAMAGE (FOD) PREVENTION | Program Manager Initial
 | 4800 - NOMP AWCAP | 1200 - FOREIGN OBJECT DAMAGE (FOD) PREVENTION | Program Manager Annual
 | 4900 - EXPLOSIVES HANDLING PERSONNEL QUALIFICATION AND CERTIFICATION | 1300 - TOOL CONTROL | Annual Program Audit/New Monitor Assignment
 | 5000 - AIRCRAFT ARMAMENT SYSTEMS (AAS) | 1300 - TOOL CONTROL | QA Annual
 | 5100 - ARAMAMENT WEAPONS SUPPORT EQUIPMENT (AWSE) | 1300 - TOOL CONTROL | Program Manager Initial
 | 5200 - AVIATION LIFE SUPPORT SYSTEMS (ALSS) | 1300 - TOOL CONTROL | Program Manager Annual
 | 5300 - AIRCRAFT SURVIVABILITY EQUIPMENT | 1400 - CORROSION PREVENTION AND CONTROL | Annual Program Audit/New Monitor Assignment
 | 5500 - MOBILE FACILITIES | 1400 - CORROSION PREVENTION AND CONTROL | QA Annual
 | 5600 - CDI PERIODIC (MONITOR) | 1400 - CORROSION PREVENTION AND CONTROL | Program Manager Initial
 | 5700 - PLANE CAPTAIN PERIODIC (MONITOR) | 1400 - CORROSION PREVENTION AND CONTROL | Program Manager Annual
 | 5800 - HYDRAULIC CONTAMINATION PERIODIC (MONITOR) | 1500 - PLANE CAPTAIN QUALIFICATION | Annual Program Audit/New Monitor Assignment
 | Work Center 020 | 1500 - PLANE CAPTAIN QUALIFICATION | QA Annual
 | Work Center 030 | 1500 - PLANE CAPTAIN QUALIFICATION | Program Manager Initial
 | Work Center 040 | 1500 - PLANE CAPTAIN QUALIFICATION | Program Manager Annual
 | Work Center 05D | 1600 - EGRESS AND EXPLOSIVE SYSTEMS CHECKOUT | Annual Program Audit/New Monitor Assignment
 | Work Center 120 | 1600 - EGRESS AND EXPLOSIVE SYSTEMS CHECKOUT | QA Annual
 | Work Center 12C | 1600 - EGRESS AND EXPLOSIVE SYSTEMS CHECKOUT | Program Manager Initial
 | Work Center 13A | 1600 - EGRESS AND EXPLOSIVE SYSTEMS CHECKOUT | Program Manager Annual
 | Work Center 140 | 1700 - SUPPORT EQUIPMENT OPERATOR TRAINING AND LICENSING | Annual Program Audit/New Monitor Assignment
 | Work Center 220 | 1700 - SUPPORT EQUIPMENT OPERATOR TRAINING AND LICENSING | QA Annual
 | Work Center 230 | 1700 - SUPPORT EQUIPMENT OPERATOR TRAINING AND LICENSING | Program Manager Initial
 | Work Center 310 | 1700 - SUPPORT EQUIPMENT OPERATOR TRAINING AND LICENSING | Program Manager Annual
 |  | 1800 - SUPPORT EQUIPMENT MAINTENANCE | Annual Program Audit/New Monitor Assignment
 |  | 1800 - SUPPORT EQUIPMENT MAINTENANCE | QA Annual
 |  | 1800 - SUPPORT EQUIPMENT MAINTENANCE | Program Manager Initial
 |  | 1800 - SUPPORT EQUIPMENT MAINTENANCE | Program Manager Annual
 |  | 1900 - TECHNICAL DATA MANAGEMENT | Annual Program Audit/New Monitor Assignment
 |  | 1900 - TECHNICAL DATA MANAGEMENT | QA Annual
 |  | 1900 - TECHNICAL DATA MANAGEMENT | Program Manager Initial
 |  | 1900 - TECHNICAL DATA MANAGEMENT | Program Manager Annual
 |  | 2000 - NAVAL AVIATION METROLOGY AND CALIBRATION | Annual Program Audit/New Monitor Assignment
 |  | 2000 - NAVAL AVIATION METROLOGY AND CALIBRATION | QA Annual
 |  | 2000 - NAVAL AVIATION METROLOGY AND CALIBRATION | Program Manager Initial
 |  | 2000 - NAVAL AVIATION METROLOGY AND CALIBRATION | Program Manager Annual
 |  | 2200 - HAZARDOUS MATERIAL CONTROL AND MANAGEMENT | Annual Program Audit/New Monitor Assignment
 |  | 2200 - HAZARDOUS MATERIAL CONTROL AND MANAGEMENT | QA Annual
 |  | 2200 - HAZARDOUS MATERIAL CONTROL AND MANAGEMENT | Program Manager Initial
 |  | 2200 - HAZARDOUS MATERIAL CONTROL AND MANAGEMENT | Program Manager Annual
 |  | 2400 - ELECTROSTATIC DISCHARGE (ESD) PROTECTION / ELECTROMAGNETIC INTERFERENCE (EMI) REPORTING | Annual Program Audit/New Monitor Assignment
 |  | 2400 - ELECTROSTATIC DISCHARGE (ESD) PROTECTION / ELECTROMAGNETIC INTERFERENCE (EMI) REPORTING | QA Annual
 |  | 2400 - ELECTROSTATIC DISCHARGE (ESD) PROTECTION / ELECTROMAGNETIC INTERFERENCE (EMI) REPORTING | Program Manager Initial
 |  | 2400 - ELECTROSTATIC DISCHARGE (ESD) PROTECTION / ELECTROMAGNETIC INTERFERENCE (EMI) REPORTING | Program Manager Annual
 |  | 2600 - TECHICAL DIRECTIVE (TD) COMPLIANCE | Annual Program Audit/New Monitor Assignment
 |  | 2600 - TECHICAL DIRECTIVE (TD) COMPLIANCE | QA Annual
 |  | 2600 - TECHICAL DIRECTIVE (TD) COMPLIANCE | Program Manager Initial
 |  | 2600 - TECHICAL DIRECTIVE (TD) COMPLIANCE | Program Manager Annual
 |  | 2700 - ELECTRICAL WIRING INTERCONNECT SYSTEM (EWIS) | Annual Program Audit/New Monitor Assignment
 |  | 2700 - ELECTRICAL WIRING INTERCONNECT SYSTEM (EWIS) | QA Annual
 |  | 2700 - ELECTRICAL WIRING INTERCONNECT SYSTEM (EWIS) | Program Manager Initial
 |  | 2700 - ELECTRICAL WIRING INTERCONNECT SYSTEM (EWIS) | Program Manager Annual
 |  | 2900 - MAINTENANCE CONTROL | Annual Program Audit/New Monitor Assignment
 |  | 2900 - MAINTENANCE CONTROL | QA Annual
 |  | 2900 - MAINTENANCE CONTROL | Program Manager Initial
 |  | 2900 - MAINTENANCE CONTROL | Program Manager Annual
 |  | 3100 - WEIGHT AND BALANCE | Annual Program Audit/New Monitor Assignment
 |  | 3100 - WEIGHT AND BALANCE | QA Annual
 |  | 3100 - WEIGHT AND BALANCE | Program Manager Initial
 |  | 3100 - WEIGHT AND BALANCE | Program Manager Annual
 |  | 3300 - LOGS AND RECORDS | Annual Program Audit/New Monitor Assignment
 |  | 3300 - LOGS AND RECORDS | QA Annual
 |  | 3300 - LOGS AND RECORDS | Program Manager Initial
 |  | 3300 - LOGS AND RECORDS | Program Manager Annual
 |  | 3400 - PHASE MAINTENANCE | Annual Program Audit/New Monitor Assignment
 |  | 3400 - PHASE MAINTENANCE | QA Annual
 |  | 3400 - PHASE MAINTENANCE | Program Manager Initial
 |  | 3400 - PHASE MAINTENANCE | Program Manager Annual
 |  | 3600 - DATA ANALYSIS | Annual Program Audit/New Monitor Assignment
 |  | 3600 - DATA ANALYSIS | QA Annual
 |  | 3600 - DATA ANALYSIS | Program Manager Initial
 |  | 3600 - DATA ANALYSIS | Program Manager Annual
 |  | 3700 - MATERIAL COTROL | Annual Program Audit/New Monitor Assignment
 |  | 3700 - MATERIAL COTROL | QA Annual
 |  | 3700 - MATERIAL COTROL | Program Manager Initial
 |  | 3700 - MATERIAL COTROL | Program Manager Annual
 |  | 3800 - AIRCRAFT MAINTENANCE MATERIAL READINESS LIST (AMMRL) | Annual Program Audit/New Monitor Assignment
 |  | 3800 - AIRCRAFT MAINTENANCE MATERIAL READINESS LIST (AMMRL) | QA Annual
 |  | 3800 - AIRCRAFT MAINTENANCE MATERIAL READINESS LIST (AMMRL) | Program Manager Initial
 |  | 3800 - AIRCRAFT MAINTENANCE MATERIAL READINESS LIST (AMMRL) | Program Manager Annual
 |  | 3900 - VIBRATION ANALYSIS | Annual Program Audit/New Monitor Assignment
 |  | 3900 - VIBRATION ANALYSIS | QA Annual
 |  | 3900 - VIBRATION ANALYSIS | Program Manager Initial
 |  | 3900 - VIBRATION ANALYSIS | Program Manager Annual
 |  | 4000 - AIRCRAFT ENGINE/APU TURN-UP LICENSING | Annual Program Audit/New Monitor Assignment
 |  | 4000 - AIRCRAFT ENGINE/APU TURN-UP LICENSING | QA Annual
 |  | 4000 - AIRCRAFT ENGINE/APU TURN-UP LICENSING | Program Manager Initial
 |  | 4000 - AIRCRAFT ENGINE/APU TURN-UP LICENSING | Program Manager Annual
 |  | 4500 - BATTERY MAINTENANCE SAFETY | Annual Program Audit/New Monitor Assignment
 |  | 4500 - BATTERY MAINTENANCE SAFETY | QA Annual
 |  | 4500 - BATTERY MAINTENANCE SAFETY | Program Manager Initial
 |  | 4500 - BATTERY MAINTENANCE SAFETY | Program Manager Annual
 |  | 4600 - AERCRAFT COMPASS CALIBRATION | Annual Program Audit/New Monitor Assignment
 |  | 4600 - AERCRAFT COMPASS CALIBRATION | QA Annual
 |  | 4600 - AERCRAFT COMPASS CALIBRATION | Program Manager Initial
 |  | 4600 - AERCRAFT COMPASS CALIBRATION | Program Manager Annual
 |  | 4700 - LASER HAZARD CONTROL | Annual Program Audit/New Monitor Assignment
 |  | 4700 - LASER HAZARD CONTROL | QA Annual
 |  | 4700 - LASER HAZARD CONTROL | Program Manager Initial
 |  | 4700 - LASER HAZARD CONTROL | Program Manager Annual
 |  | 4800 - NOMP AWCAP | Annual Program Audit/New Monitor Assignment
 |  | 4800 - NOMP AWCAP | QA Annual
 |  | 4800 - NOMP AWCAP | Program Manager Initial
 |  | 4800 - NOMP AWCAP | Program Manager Annual
 |  | 4900 - EXPLOSIVES HANDLING PERSONNEL QUALIFICATION AND CERTIFICATION | Annual Program Audit/New Monitor Assignment
 |  | 4900 - EXPLOSIVES HANDLING PERSONNEL QUALIFICATION AND CERTIFICATION | QA Annual
 |  | 4900 - EXPLOSIVES HANDLING PERSONNEL QUALIFICATION AND CERTIFICATION | Program Manager Initial
 |  | 4900 - EXPLOSIVES HANDLING PERSONNEL QUALIFICATION AND CERTIFICATION | Program Manager Annual
 |  | 5000 - AIRCRAFT ARMAMENT SYSTEMS (AAS) | Annual Program Audit/New Monitor Assignment
 |  | 5000 - AIRCRAFT ARMAMENT SYSTEMS (AAS) | QA Annual
 |  | 5000 - AIRCRAFT ARMAMENT SYSTEMS (AAS) | Program Manager Initial
 |  | 5000 - AIRCRAFT ARMAMENT SYSTEMS (AAS) | Program Manager Annual
 |  | 5200 - AVIATION LIFE SUPPORT SYSTEMS (ALSS) | Annual Program Audit/New Monitor Assignment
 |  | 5200 - AVIATION LIFE SUPPORT SYSTEMS (ALSS) | QA Annual
 |  | 5200 - AVIATION LIFE SUPPORT SYSTEMS (ALSS) | Program Manager Initial
 |  | 5200 - AVIATION LIFE SUPPORT SYSTEMS (ALSS) | Program Manager Annual
 |  | 5300 - AIRCRAFT SURVIVABILITY EQUIPMENT | Annual Program Audit/New Monitor Assignment
 |  | 5300 - AIRCRAFT SURVIVABILITY EQUIPMENT | QA Annual
 |  | 5300 - AIRCRAFT SURVIVABILITY EQUIPMENT | Program Manager Initial
 |  | 5300 - AIRCRAFT SURVIVABILITY EQUIPMENT | Program Manager Annual
 |  | Work Center 020 | Work Center Supervisor Initial
 |  | Work Center 020 | Work Center Supervisor Annual
 |  | Work Center 030 | Work Center Supervisor Initial
 |  | Work Center 030 | Work Center Supervisor Annual
 |  | Work Center 040 | Work Center Supervisor Initial
 |  | Work Center 040 | Work Center Supervisor Annual
 |  | Work Center 05D | Work Center Supervisor Initial
 |  | Work Center 05D | Work Center Supervisor Annual
 |  | Work Center 120 | Work Center Supervisor Initial
 |  | Work Center 120 | Work Center Supervisor Annual
 |  | Work Center 12C | Work Center Supervisor Initial
 |  | Work Center 12C | Work Center Supervisor Annual
 |  | Work Center 13A | Work Center Supervisor Initial
 |  | Work Center 13A | Work Center Supervisor Annual
 |  | Work Center 140 | Work Center Supervisor Initial
 |  | Work Center 140 | Work Center Supervisor Annual
 |  | Work Center 220 | Work Center Supervisor Initial
 |  | Work Center 220 | Work Center Supervisor Annual
 |  | Work Center 230 | Work Center Supervisor Initial
 |  | Work Center 230 | Work Center Supervisor Annual
 |  | Work Center 310 | Work Center Supervisor Initial
 |  | Work Center 310 | Work Center Supervisor Annual
 |  | Work Center 020 | Work Center Annual
 |  | Work Center 030 | Work Center Annual
 |  | Work Center 040 | Work Center Annual
 |  | Work Center 05D | Work Center Annual
 |  | Work Center 120 | Work Center Annual
 |  | Work Center 12C | Work Center Annual
 |  | Work Center 13A | Work Center Annual
 |  | Work Center 140 | Work Center Annual
 |  | Work Center 220 | Work Center Annual
 |  | Work Center 230 | Work Center Annual
 |  | Work Center 310 | Work Center Annual