Spreadsheet: 754478d1636238601-create-7-dependent-dropdown-using-data-validation-based-on-multiple-dependent-columns-ef1555_filter_multiple_fields
Sheet: Ref_data

Period | PMU | MCO | country | Division | category | brand
All | All | All | All | All | All | All
202101 | EEE | Benelux | AUSTRIA | BCP | COFFEE | 3 SINETIN
202102 | KMI | BP | BELGIUM | FOOD & REFRESHMENTS | DEODORANT & FRAGRANCE | 4X4
202103 | ME | DACH | DENMARK | HOME CARE | DRESSING | AHC
202104 | WU | ESE | FINLAND |  | DRESSING_FS | AIM
202105 |  | France | FRANCE |  | FABRIC CLEANING | ALBERTO BALSAM
202106 |  | HUAD | GERMANY |  | FABRIC ENHANCER | [NAME]
202107 |  | Italy | HUAD |  | HAIR CARE | AMINO
202108 |  | KUI | ITALY |  | HOME & HYGIENE | AMODENT
202109 |  | Nordics | NETHERLANDS |  | ICE CREAM | AMORA
202110 |  | Portugal | NORWAY |  | ICE CREAM_FS | ANDRELON
202111 |  | RCRS | P&B |  | MEAT REPLACEMENT | ANDY
202112 |  | SCE | PORTUGAL |  | [NAME] | AXE
 |  | Spain | RCRS |  | NON CORPORATE HC CATEGORY | B FOR MEN
 |  |  | SEE |  | NON CORPORATE PC CATEGORY | BABA
 |  |  | SPAIN |  | ORAL CARE | BABASUCCO
 |  |  | SWEDEN |  | OTH FOOD | BABY DOVE
 |  |  | SWITZERLAND |  | OTH FOOD_FS | BADEDAS
 |  |  | UKI |  | PROFESSIONAL CLEANING CATEGORY | BAMSELINE
 |  |  | USCE |  | SCRATCH COOKING AID | BAR FRENDIES
 |  |  |  |  | SCRATCH COOKING AID_FS | B-BETTER
 |  |  |  |  | SKIN CARE | BECEL
 |  |  |  |  | SKIN CLEANSING | BED HEAD
 |  |  |  |  | SNACKING | BEN & JERRY'S
 |  |  |  |  | SNACKING_FS | BERTOLLI
 |  |  |  |  | SOY & FRUIT BEVERAGE | BETA
 |  |  |  |  | SOY & FRUIT BEVERAGE_FS | BETAFRIT
 |  |  |  |  | SPREAD | BETTY ICE
 |  |  |  |  | SPREAD_FS | BIG MILK
 |  |  |  |  | TEA | BIO LUVIL
 |  |  |  |  | TEA_FS | BIOLIT
 |  |  |  |  | VITAMIN, MINERAL & SUPPLEMENT | BIOTEX
 |  |  |  |  | WEIGHT MANAGEMENT | BISTEFANI
 |  |  |  |  |  | BONANZA
 |  |  |  |  |  | BOURSIN
 |  |  |  |  |  | BOVRIL
 |  |  |  |  |  | BREYERS
 |  |  |  |  |  | BROOKE BOND
 |  |  |  |  |  | BRUT
 |  |  |  |  |  | BRYLCREEM
 |  |  |  |  |  | CABINETS
 |  |  |  |  |  | CAFE ZERO
 |  |  |  |  |  | CAJOLINE
 |  |  |  |  |  | CALVE
 |  |  |  |  |  | CARTE D'OR
 |  |  |  |  |  | CATWALK
 |  |  |  |  |  | CEBRALIN
 |  |  |  |  |  | Chicken Tonight
 |  |  |  |  |  | CHIRAT
 |  |  |  |  |  | CHOICE
 |  |  |  |  |  | CIF
 |  |  |  |  |  | CLEAR
 |  |  |  |  |  | CLEAR MEN
 |  |  |  |  |  | CLOSE UP
 |  |  |  |  |  | COCCOLINO
 |  |  |  |  |  | COLMAN'S
 |  |  |  |  |  | COMFORT
 |  |  |  |  |  | COMTESSA
 |  |  |  |  |  | CONIMEX
 |  |  |  |  |  | COPYRIGHT
 |  |  |  |  |  | COPYRIGHT COLOUR
 |  |  |  |  |  | CORAL
 |  |  |  |  |  | CORNETTO
 |  |  |  |  |  | CREME BONJOUR
 |  |  |  |  |  | CREMISSIMO
 |  |  |  |  |  | CUP A SOUP
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | DAY2
 |  |  |  |  |  | DE!NY
 |  |  |  |  |  | DELIKAT
 |  |  |  |  |  | DENNY
 |  |  |  |  |  | DERO
 |  |  |  |  |  | DEXTRO
 |  |  |  |  |  | DIFFUSIL
 |  |  |  |  |  | DIMENSION
 |  |  |  |  |  | DOB (F&R)
 |  |  |  |  |  | DOB FOOD SOLUTIONS
 |  |  |  |  |  | DOLCEVITA
 |  |  |  |  |  | DOMESTOS
 |  |  |  |  |  | DOVE
 |  |  |  |  |  | DOVE MEN+CARE
 |  |  |  |  |  | DR. SWEAT
 |  |  |  |  |  | DRIEHOEK
 |  |  |  |  |  | DU DARFST
 |  |  |  |  |  | DUSCHDAS
 |  |  |  |  |  | EFFI
 |  |  |  |  |  | ELAIS
 |  |  |  |  |  | ELEPHANT (F&R)
 |  |  |  |  |  | ELIDA
 |  |  |  |  |  | ELIDOR
 |  |  |  |  |  | ENKA
 |  |  |  |  |  | EQUILIBRA
 |  |  |  |  |  | ESKIMO
 |  |  |  |  |  | EVGA
 |  |  |  |  |  | FATTI PER TE
 |  |  |  |  |  | FERMETTE
 |  |  |  |  |  | FISSAN
 |  |  |  |  |  | FLORA
 |  |  |  |  |  | FLORASZEPT
 |  |  |  |  |  | FLUOCARIL
 |  |  |  |  |  | FOOD SOLUTIONS
 |  |  |  |  |  | FRUFRU
 |  |  |  |  |  | FRUIT D'OR
 |  |  |  |  |  | FRUIT ZERO
 |  |  |  |  |  | GABI
 |  |  |  |  |  | GARDE D'OR
 |  |  |  |  |  | Gelina
 |  |  |  |  |  | GLOBUS
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | GLYSOLID
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | GROM
 |  |  |  |  |  | HAPPINESS STATION
 |  |  |  |  |  | HEART LB
 |  |  |  |  |  | HELLMANN'S
 |  |  |  |  |  | HERA
 |  |  |  |  |  | HERTOG
 |  |  |  |  |  | ICBISG
 |  |  |  |  |  | IGLO
 |  |  |  |  |  | IMPULSE
 |  |  |  |  |  | INGMAN
 |  |  |  |  |  | INGMAN CREAMY
 |  |  |  |  |  | INTIBIOME
 |  |  |  |  |  | JATTIS
 |  |  |  |  |  | JIF (F&R)
 |  |  |  |  |  | KARABOLA
 |  |  |  |  |  | KINDER (UNILEVER)
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | KLINEX
 |  |  |  |  |  | KLOVER
 |  |  |  |  |  | KNORR
 |  |  |  |  |  | KUNER
 |  |  |  |  |  | LA DULCERIA
 |  |  |  |  |  | LESS
 |  |  |  |  |  | LIFEBUOY
 |  |  |  |  |  | LIGERESA
 |  |  |  |  |  | LINIC
 |  |  |  |  |  | LINIC MEN
 |  |  |  |  |  | LIPTON
 |  |  |  |  |  | LIPTON FUSION
 |  |  |  |  |  | LIPTON YELLOW LABEL
 |  |  |  |  |  | LOVE BEAUTY AND PLANET
 |  |  |  |  |  | LOVE HOME AND PLANET
 |  |  |  |  |  | LUKULL
 |  |  |  |  |  | LUX
 |  |  |  |  |  | LYNX
 |  |  |  |  |  | LYONS
 |  |  |  |  |  | LYSOFORM
 |  |  |  |  |  | MAGIC (F&R)
 |  |  |  |  |  | MAGNUM
 |  |  |  |  |  | MAILLE
 |  |  |  |  |  | MAIZENA
 |  |  |  |  |  | MARMITE
 |  |  |  |  |  | MATEY
 |  |  |  |  |  | MAX
 |  |  |  |  |  | MAZOLA
 |  |  |  |  |  | ME FOOD
 |  |  |  |  |  | MEDOVA
 |  |  |  |  |  | MENTADENT
 |  |  |  |  |  | MILDA
 |  |  |  |  |  | MILK TIME
 |  |  |  |  |  | MIMOSIN
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | MON PETIT GLACIER
 |  |  |  |  |  | MONDAMIN
 |  |  |  |  |  | MONSAVON
 |  |  |  |  |  | MONTANIA
 |  |  |  |  |  | MOUSSEL
 |  |  |  |  |  | Napoca
 |  |  |  |  |  | NEUTRAL
 |  |  |  |  |  | NEUTRAZERO
 |  |  |  |  |  | NEXXUS
 |  |  |  |  |  | NICE BY NATURE
 |  |  |  |  |  | NON BRANDED F&R
 |  |  |  |  |  | NUMBER 1
 |  |  |  |  |  | O'HOJ
 |  |  |  |  |  | OMO
 |  |  |  |  |  | ORTHOSAN
 |  |  |  |  |  | OSWALD
 |  |  |  |  |  | OTHER BRANDS (F&R)
 |  |  |  |  |  | OVOCHEF
 |  |  |  |  |  | PAROGENCYL
 |  |  |  |  |  | PEARS
 |  |  |  |  |  | PELARGOS
 |  |  |  |  |  | PENTO
 |  |  |  |  |  | PEPERAMI
 |  |  |  |  |  | PEPSODENT
 |  |  |  |  |  | PERSIL
 |  |  |  |  |  | PETIT CHERI
 |  |  |  |  |  | PFANNI
 |  |  |  |  |  | PG TIPS
 |  |  |  |  |  | PHASE
 |  |  |  |  |  | PLANT LINE
 |  |  |  |  |  | PONDS
 |  |  |  |  |  | POT NOODLE
 |  |  |  |  |  | PREP CO
 |  |  |  |  |  | PRESTO
 |  |  |  |  |  | PRO ACTIV
 |  |  |  |  |  | PROBAT
 |  |  |  |  |  | PRODENT
 |  |  |  |  |  | PRODERM
 |  |  |  |  |  | PUKKA
 |  |  |  |  |  | PUMMARO
 |  |  |  |  |  | PUR' FRUIT
 |  |  |  |  |  | PURE LEAF
 |  |  |  |  |  | RADION
 |  |  |  |  |  | RADOX
 |  |  |  |  |  | RAMA
 |  |  |  |  |  | REAL ICED TEA
 |  |  |  |  |  | RED RED
 |  |  |  |  |  | REGENERATE
 |  |  |  |  |  | REXONA
 |  |  |  |  |  | R-ICE
 |  |  |  |  |  | ROBIJN
 |  |  |  |  |  | ROCKAHOLIC
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | S FACTOR
 |  |  |  |  |  | S3
 |  |  |  |  |  | SAGA
 |  |  |  |  |  | SAIS
 |  |  |  |  |  | SAVO
 |  |  |  |  |  | SAVORA
 |  |  |  |  |  | SCANDAL
 |  |  |  |  |  | [NAME]'S
 |  |  |  |  |  | SCOTTISH BLEND
 |  |  |  |  |  | SEVENTH GENERATION
 |  |  |  |  |  | SHEAMOISTURE
 |  |  |  |  |  | SIGNAL
 |  |  |  |  |  | SIMPLE
 |  |  |  |  |  | SKIP
 |  |  |  |  |  | SLIM FAST
 |  |  |  |  |  | SLOTTS
 |  |  |  |  |  | SNOG
 |  |  |  |  |  | SOFT REPUBLICK
 |  |  |  |  |  | SOLERO
 |  |  |  |  |  | ST IVES
 |  |  |  |  |  | STARLUX
 |  |  |  |  |  | STATUS
 |  |  |  |  |  | STREU MI
 |  |  |  |  |  | SUN
 |  |  |  |  |  | SUNIL
 |  |  |  |  |  | SUNLIGHT
 |  |  |  |  |  | SUNSILK
 |  |  |  |  |  | SURE
 |  |  |  |  |  | SURF
 |  |  |  |  |  | SVELTO
 |  |  |  |  |  | SWEDISH GLACE
 |  |  |  |  |  | [NAME]'S
 |  |  |  |  |  | T.O
 |  |  |  |  |  | T2
 |  |  |  |  |  | TABORT
 |  |  |  |  |  | TE ATI
 |  |  |  |  |  | THE RIGHT TO SHOWER
 |  |  |  |  |  | THE VEGETARIAN BUTCHER
 |  |  |  |  |  | TIGI
 |  |  |  |  |  | TIMOTEI
 |  |  |  |  |  | TOFULINE
 |  |  |  |  |  | TONI & GUY
 |  |  |  |  |  | TORTEX
 |  |  |  |  |  | TRESEMME
 |  |  |  |  |  | TURUN SINAPPIA
 |  |  |  |  |  | ULTREX
 |  |  |  |  |  | ULTREX MEN
 |  |  |  |  |  | UNILEVER
 |  |  |  |  |  | UNOX
 |  |  |  |  |  | UNOX UNO
 |  |  |  |  |  | URBAN MONKEY
 |  |  |  |  |  | VARIETE
 |  |  |  |  |  | VASELINE
 |  |  |  |  |  | VASELINE MEN
 |  |  |  |  |  | VASENOL
 |  |  |  |  |  | VIA
 |  |  |  |  |  | VIENNETTA
 |  |  |  |  |  | VINOLIA
 |  |  |  |  |  | VISS
 |  |  |  |  |  | VITAM
 |  |  |  |  |  | VO5
 |  |  |  |  |  | WHITE NOW
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | WINBORGS
 |  |  |  |  |  | Y3
 |  |  |  |  |  | YULA
 |  |  |  |  |  | ZENDIUM
 |  |  |  |  |  | ZWAN
 |  |  |  |  |  | ZWITSAL