Spreadsheet: 101889d1299943457-and-or-vlookup-formula-if-or-and-problem
Sheet: Sheet1

 |  | [NAME] not working below |  | Answer in column C should be
Industry Leadership | NEE-UKI | #N/A
Industry Leadership | NEE-UKI | #N/A
Industry Leadership | SWE-BeNeLux | #N/A |  | Consolidated
Industry Leadership | SWE-France | #N/A |  | Consolidated
Industry Leadership | SWE-Italy | #N/A
Industry Leadership | SWE-Italy | #N/A
Industry Leadership | SWE-Italy | #N/A
LM Coordinated Audiences | GMU-ASEAN | Capability |  | Capability
LM Coordinated Audiences | GMU-ASEAN | Capability |  | Capability
LM Coordinated Audiences | GMU-ASEAN | Capability |  | Capability
LM Coordinated Audiences | GMU-ASEAN | Capability |  | Capability
LM Coordinated Audiences | GMU-ASEAN | Capability |  | Capability
LM Coordinated Audiences | GMU-ASEAN | Capability |  | Capability
LM Coordinated Audiences | GMU-CEE | Capability |  | Capability
LM Coordinated Audiences | GMU-CEE | Capability |  | Capability
LM Coordinated Audiences | GMU-GCG | Capability |  | Capability
LM Coordinated Audiences | GMU-GCG | Capability |  | Capability
LM Coordinated Audiences | GMU-GCG | Capability |  | Capability
LM Coordinated Audiences | GMU-India-South Asia | Capability |  | Capability
LM Coordinated Audiences | GMU-India-South Asia | Capability |  | Capability
Industry Leadership | GMU-ASEAN | #N/A |  | Consolidated
Industry Leadership | GMU-ASEAN | #N/A |  | Consolidated
Industry Leadership | GMU-ASEAN | #N/A |  | Consolidated
Industry Leadership | GMU-ASEAN | #N/A |  | Consolidated
Industry Leadership | GMU-A/NZ | #N/A
Industry Leadership | GMU-A/NZ | #N/A
Industry Leadership | GMU-A/NZ | #N/A
Industry Leadership | GMU-CEE | #N/A |  | Consolidated
Industry Leadership | GMU-CEE | #N/A |  | Consolidated
Industry Leadership | GMU-CEE | #N/A |  | Consolidated
Industry Leadership | GMU-CEE | #N/A |  | Consolidated
Industry Leadership | GMU-GCG | #N/A |  | Consolidated
Industry Leadership | GMU-India-South Asia | #N/A |  | Consolidated
Industry Leadership | GMU-Korea | #N/A |  | Consolidated
Industry Leadership | GMU-Korea | #N/A |  | Consolidated
Industry Leadership | GMU-MEA | #N/A |  | Consolidated
Industry Leadership | GMU-MEA | #N/A |  | Consolidated
Industry Leadership | GMU-MEA | #N/A |  | Consolidated
Industry Leadership | GMU-MEA | #N/A |  | Consolidated
Business Agility | GMU-India-South Asia | Capability |  | Consolidated
Leveraging IT Services | GMU-A/NZ | Capability |  | Consolidated
Workload Optimized Systems | NEE-UKI | Capability |  | Consolidated
Workload Optimized Systems | NA-United States | Capability |  | Consolidated
Workload Optimized Systems | NA-Canada | Capability |  | Consolidated
C-Suite | GMU-MEA | #N/A |  | Capability
C-Suite | GMU-MEA | #N/A |  | Capability
C-Suite | GMU-MEA | #N/A |  | Capability
C-Suite | GMU-MEA | #N/A |  | Capability
C-Suite | GMU-India-South Asia | #N/A |  | Capability
C-Suite | GMU-A/NZ | #N/A
C-Suite | NEE-UKI | #N/A
C-Suite | NA-United States | #N/A
C-Suite | NA-Canada | #N/A
C-Suite | GMU-CEE | #N/A |  | Capability
C-Suite | GMU-GCG | #N/A |  | Capability
C-Suite | GMU-India-South Asia | #N/A |  | Capability
Midmarket | GMU-MEA
Midmarket | GMU-India-South Asia
Midmarket | GMU-A/NZ
Midmarket | NEE-UKI
Midmarket | NA-United States
Midmarket | NA-Canada