Spreadsheet: 694653d1599737109-excel-lookup-and-countif-issue-example-100920
Sheet: Dropdowns

 |  |  |  |  |  |  |  |  |  | GBP
 |  | UK | Very High | LSE | High |  | [NAME] / agribusiness | Medium | USD | 1.25 | US
 |  | US | High | AIM | Medium |  | AI / Robots | High | EUR | 1.11 | EURO
 |  | Global | High/Medium | NYSE | Low |  | Automotive | Low | [NAME] | 134.03 | JAPAN
 |  | Japan | Medium | NASDAQ |  |  | Batteries | Medium | CNY | 8.82 | CHINA
 |  | China | Medium/Low | JPX |  |  | [NAME]-currencies | High | AUD | 1.8 | AUSTRALIA
 |  | Korea | Low | SSX (Shanghai) |  |  | Chemicals / Metals / Materials | Low | KRW | 1499.56 | KOREA
 |  | France |  | SHEK (Hong Kong) |  |  | Conglomerate | Low | IDR | 17973.35 | INDONESIA
 |  | Germany |  | [NAME] (Shenzhen) |  |  | Crowdsurfing | High | GBP | 1 | UK
 |  | Italy |  | KRX |  |  | Defence / Aerospace | Low | SEK | 11.63 | SWEDEN
 |  | Spain |  | Euronext (France) |  |  | Electronics / Semi-conductors | Low | CAD | 1.7 | CANADA
 |  | Scandinavia |  | FWB (Germany) |  |  | Energy / Renewables / Utilities | Low | PEN | 4.39 | PERU
 |  | Switzerland |  | Euronext (Holland) |  |  | Engineering / Tools / Infrastructure | Low | [NAME] | 27.81 | MEXICO
 |  | Europe |  | TSX (Canada) |  |  | Exchanges | Low | BRL | 6.66 | BRAZIL
 |  | Taiwan |  | SIX (Switzerland) |  |  | Financial Services / Fintech / Banks | Low | CHF | 1.19 | SWITZERLAND
 |  | Oceania |  | BSE (India) |  |  | FitTech / Mapping | High | HKD | 9.78 | HONG KONG
 |  | Latin America |  | NSE (India) |  |  | FMCG/Consumer Goods/Luxury | Medium | RUB | 89.13 | RUSSIA
 |  | Africa |  | ASX (Australia) |  |  | Food & Drink | Low | ZAR | 21.1 | SOUTH AFRICA
 |  | SE Asia |  | Copenhagen |  |  | Forestry / Paper | Low | DKK | 8.22 | DENMARK
 |  | Middle East |  | Stockholm |  |  | GovTech | High | INR | 94.15 | INDIA
 |  | Russia |  | Helsinki |  |  | Healthcare | Low | ILS | 4.32 | ISRAEL
 |  | India |  | Oslo |  |  | Indices | Low | NOK | 11.68 | NORWAY
 |  | Canada |  | Taiwan |  |  | Insurance | Low | SGD | 1.75 | SINGAPORE
 |  | Mexico |  | Brazil |  |  | IoT | High | AED | 4.62 | ABU DHABI
 |  | Far East |  | South Africa |  |  | Longevity | Medium | SAR | 4.71 | SAUDI ARABIA
 |  | Central Asia |  | BME (Spain) |  |  | Manufacturing | Medium | TWD | 37.03 | TAIWAN
 |  |  |  | BIT (Italy) |  |  | MarComms/Advertising Agency | Medium | THB | 39.79 | THAILAND
 |  |  |  | Colombia |  |  | Media | Medium | TRY | 8.62 | TURKEY
 |  |  |  | Venezuela |  |  | Mining | Low
 |  |  |  | Chile |  |  | Oil & Gas | Low
 |  |  |  | Philippines |  |  | Pharma / Biotech | Medium
 |  |  |  | Singapore |  |  | Property / Land / Construction | Low
 |  |  |  | Malaysia |  |  | Retail | Medium
 |  |  |  | Indonesia |  |  | Software / Consulting | Medium
 |  |  |  | Saudi Arabia |  |  | SpaceTech | High
 |  |  |  |  |  |  | Support Services | Medium
 |  |  |  |  |  |  | Technology | Medium
 |  |  |  |  |  |  | Telecoms | Medium
 |  |  |  |  |  |  | Transport / Shipping / Logistics | Low
 |  |  |  |  |  |  | Travel / Airlines / Tourism / Leisure | High
 |  |  |  |  |  |  | VC | High
 |  |  |  |  |  |  | VR / AR | High
 |  |  |  |  |  |  | Waste Management | Low
 |  |  |  |  |  |  | [NAME] | Medium
 |  |  |  |  |  |  | 0