Spreadsheet: 74312d1274860373-how-to-you-convert-condition-to-formula-sample-lookup
Sheet: Source

Universal Code | Universal ID | Universal Category | AUSTRALIA |  |  | CANADA |  |  | USA |  |  | EUROPE |  |  | ASIA |  |  | AFRICA |  |  | THAILAND
 |  |  | Country Code | Country ID | QTY | Country Code | Country ID | QTY | Country Code | Country ID | QTY | Country Code | Country ID | QTY | Country Code | Country ID | QTY | Country Code | Country ID | QTY | Country Code | Country ID | QTY
1026632 | 65336 | SCENT | 63209 | AU |  |  |  |  |  |  |  | 8077800 | EU | 308 | 2060009 | AS | 145 | 5024400 | AF |  | 1192600 | TH | 1928
1026632 | 374661 | SCENT |  |  |  | 3373250 | CN
1026633 | 65337 | SCENT |  |  |  |  |  |  |  |  |  | 8077700 | EU | 991 | 2060010 | AS |  | 4098640 | AF |  | 1200900 | TH
1026633 | 352026 | SCENT |  |  |  |  |  |  |  |  |  |  |  |  | 2061200 | AS | 237
1026634 | 65338 | SCENT | 63429 | AU
1026636 | 97754 | SCENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9461900 | AF
1026636 | 240211 | SCENT | 63609 | AU
1026637 | 65287 | SCENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6661800 | AF
1026644 | 65103 | PERSONAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9846500 | TH
1026691 | 244778 | PERSONAL |  |  |  |  |  |  | 116867 | US | 9007 | 8080200 | EU | 2791 | 4060210 | AS | 2818 |  |  |  | 1202400 | TH | 163
1026692 | 274213 | PERSONAL |  |  |  |  |  |  | 116865 | US | 6701 | 8091400 | EU |  | 4060209 | AS | 2318
1026693 | 209346 | PERSONAL |  |  |  |  |  |  |  |  |  | 8090300 | EU |  | 4060215 | AS | 219 |  |  |  | 1205200 | TH
1027133 | 66241 | SCENT |  |  |  |  |  |  |  |  |  | 8090700 | EU | 26 |  | AS |  | 3019070 | AF
1027134 | 66245 | FRAGRANCE |  |  |  |  |  |  |  |  |  | 8091300 | EU |  |  | AS |  | 3019060 | AF
1027135 | 66248 | FRAGRANCE |  |  |  |  |  |  |  |  |  | 8095000 | EU | 26 |  | AS |  | 3019050 | AF
1027140 | 66255 | FRAGRANCE | 14039 | AU |  |  |  |  |  |  |  | 8089500 | EU |  |  | AS
1027154 | 66284 | FRAGRANCE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9690800 | AF
1027160 | 73476 | PERSONAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302251 | AF
1027160 | 96719 | PERSONAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W001178 | AF
1027170 | 66295 | PERSONAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3022540 | AF
1027172 | 73477 | PERSONAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3049650 | AF
1027173 | 73478 | PERSONAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3042230 | AF
1027205 | 66449 | PERSONAL |  |  |  |  |  |  |  |  |  |  |  |  | 4060247 | AS | 13106
1027206 | 66450 | PERSONAL | 72309 | AU |  |  |  |  |  |  |  |  |  |  | 4060246 | AS | 882 |  |  |  | 9601000 | TH | 19
1027303 | 274214 | PERSONAL |  |  |  |  |  |  |  |  |  |  |  |  | 4050106 | AS
1027315 | 76504 | SKIN | 31539 | AU |  |  |  |  |  |  |  | 8092200 | EU | 29 | 5070020 | AS | 184 | 3040599 | AF |  | 9301100 | TH
1027315 | 344755 | SKIN |  |  |  |  |  |  |  |  |  |  |  |  | 5070050 | AS
1027952 | 74497 | PERSONAL |  |  |  |  |  |  |  |  |  | 8067600 | EU | 1 | 4050098 | AS
1027956 | 74501 | PERSONAL |  |  |  |  |  |  |  |  |  |  |  |  | 7050002 | AS
1027965 | 75779 | PERSONAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6657400 | AF
1028267 | 78174 | PAINT |  |  |  |  |  |  |  |  |  | 8092510 | EU | 117 | 1061057 | AS | 2 |  |  |  | 8544400 | TH
1028267 | 78175 | PAINT |  |  |  |  |  |  |  |  |  | 8092520 | EU |  | 1061058 | AS |  |  |  |  | 8544300 | TH
1028267 | 78176 | PAINT | 26709 | AU |  |  |  |  |  |  |  |  |  |  | 1061059 | AS |  |  |  |  | 8544500 | TH
1028474 | 96526 | HAIR |  |  |  |  |  |  |  |  |  | 8079000 | EU | 32 | 4060014 | AS |  |  |  |  | 9858700 | TH
1028477 | 96528 | HAIR |  |  |  |  |  |  |  |  |  | 8080700 | EU |  | 4060225 | AS | 1176 |  |  |  | 9858800 | TH | 2
1028490 | 76260 | SKIN |  |  |  |  |  |  |  |  |  | 8075900 | EU | 1224.15 |  | AS
1028515 | 76258 | SCENT |  |  |  |  |  |  | 116307 | US | 299
1028517 | 76263 | SCENT |  |  |  |  |  |  | 116305 | US
1028524 | 358324 | SCENT |  |  |  |  |  |  |  |  |  | 8089100 | EU | 24 |  | AS
1028566 | 76411 | SCENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1832600 | AF
1028611 | 76932 | SCENT |  |  |  |  |  |  | 18611500 | US | 376
1028613 | 76654 | SCENT |  |  |  |  |  |  | 18613500 | US | 1
1028615 | 359413 | SCENT |  |  |  |  |  |  | 18615500 | US | 307
1028616 | 390227 | SCENT |  |  |  |  |  |  | 18616500 | US | 1371
1028617 | 390229 | SCENT |  |  |  |  |  |  | 18617500 | US | 64
1028621 | 76545 | SCENT |  |  |  |  |  |  |  |  |  | 8097100 | EU | 390 |  | AS |  | 9188800 | AF | 350
1029290 | 78804 | PAINT | 9299 | AU | 120 |  |  |  |  |  |  | 8091610 | EU | 21 | 1062901 | AS |  |  |  |  | 8540700 | TH | 10
1029290 | 78805 | PAINT |  |  |  |  |  |  |  |  |  | 8091640 | EU | 10 | 1071018 | AS |  |  |  |  | 8541600 | TH
1029290 | 78806 | PAINT |  |  |  |  |  |  |  |  |  | 8095910 | EU | 5 | 1062902 | AS |  | 2270060 | AF |  | 8540800 | TH
1029290 | 78807 | PAINT |  |  |  |  |  |  |  |  |  | 8095920 | EU | 4 | 1062904 | AS |  |  |  |  | 8541000 | TH
1029290 | 78808 | PAINT | 9296 | AU |  |  |  |  |  |  |  | 8091630 | EU | 6 | 1062903 | AS |  | 2270080 | AF |  | 8540900 | TH
1029290 | 78809 | PAINT |  |  |  |  |  |  |  |  |  |  |  |  | 1071015 | AS |  |  |  |  | 8541300 | TH
1029290 | 78810 | PAINT | 9298 | AU |  |  |  |  |  |  |  | 8091620 | EU | 42 | 1071017 | AS |  | 2270090 | AF |  | 8541500 | TH
1029290 | 78812 | PAINT |  |  |  |  |  |  |  |  |  |  |  |  | 1071016 | AS |  | 2270100 | AF |  | 8541400 | TH
1029290 | 78813 | PAINT | 9297 | AU |  |  |  |  |  |  |  | 8091650 | EU | 17 | 1062906 | AS |  | 2270050 | AF |  | 8541200 | TH
1029290 | 97368 | PAINT |  |  |  |  |  |  |  |  |  | 8091660 | EU | 5 | 1062905 | AS |  | 2270070 | AF |  | 8541100 | TH
1029290 | 189165 | PAINT |  |  |  |  |  |  |  |  |  | 8096310 | EU |  | 1071019 | AS |  | 2269030 | AF |  | 8546100 | TH
1029290 | 189166 | PAINT |  |  |  |  |  |  |  |  |  | 8096330 | EU |  | 1071020 | AS |  | 2269040 | AF |  | 8546200 | TH
1029290 | 189167 | PAINT |  |  |  |  |  |  |  |  |  | 8096320 | EU |  | 1071021 | AS |  | 2269050 | AF |  | 8546300 | TH
1029290 | 209402 | PAINT
1029538 | 78258 | SCENT | 53819 | AU
1029538 | 356470 | SCENT | 53899 | AU
1029540 | 78259 | SCENT | 54029 | AU
1029569 | 86095 | PAINT | 56908 | AU | 761.23 |  |  |  | 114361 | US | 9470 |  |  |  | 3061013 | AS |  |  |  |  | 8531700 | TH
1029569 | 96816 | PAINT | 95694 | AU |  |  |  |  | 115264 | US | 10406 | 8093830 | EU | 4 | 3061012 | AS
1029569 | 96817 | PAINT | 56910 | AU |  |  |  |  | 114344 | US | 271
1029569 | 96818 | PAINT |  |  |  |  |  |  |  |  |  | 8086610 | EU | 2 |  | AS
1029569 | 96832 | PAINT |  |  |  |  |  |  | 114345 | US | 1980
1029569 | 96833 | PAINT | 96593 | AU |  |  |  |  |  |  |  |  |  |  | 3061007 | AS
1029569 | 96835 | PAINT | 56909 | AU | 3648.97 |  |  |  | A0006006 | US |  |  |  |  | H002247 | AS |  |  |  |  | 8531900 | TH | 455
1029569 | 96854 | PAINT | 56905 | AU |  |  |  |  | 114358 | US | 349
1029569 | 96856 | PAINT | 56904 | AU | 10008.81 |  |  |  | 114354 | US | 2764 | 8086605 | EU |  |  | AS
1029569 | 96857 | PAINT | 56903 | AU |  |  |  |  | 114346 | US | 10482 |  |  |  | 3061015 | AS |  |  |  |  | 8531500 | TH | 195
1029569 | 96858 | PAINT | 56902 | AU |  |  |  |  | 114352 | US | 4645
1032360 | 96266 | PAINT | 36068 | AU |  |  |  |  | 115385 | US | 3586 | 8139410 | EU |  | 1101391 | AS |  |  |  |  | 8598600 | TH | 1202
1032360 | 96267 | PAINT | 36069 | AU
1032360 | 96269 | PAINT |  |  |  |  |  |  |  |  |  | 8139420 | EU | 1521.56 | 1101390 | AS |  |  |  |  | 8598500 | TH | 570
1032361 | 96270 | PAINT | 36138 | AU
1032361 | 96271 | PAINT | 36139 | AU
1032364 | 88519 | SCENT |  |  |  |  |  |  |  |  |  | 8118500 | EU | 10865.61 | 2081118 | AS |  |  |  |  | 1206700 | TH | 597
1032365 | 88520 | SCENT | 23659 | AU | 51
1032371 | 96292 | PAINT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7427000 | AF
1032371 | 96293 | PAINT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 374700 | AF
1032371 | 96294 | PAINT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 374500 | AF
1032376 | 88976 | SCENT | 30920 | AU |  |  |  |  |  |  |  |  |  |  |  |  |  | 3030921 | AF
1032390 | 244565 | SCENT |  |  |  |  |  |  |  |  |  | 8085200 | EU |  | 2060037 | AS |  |  |  |  | 1202700 | TH | 5217
1033326 | 244553 | SCENT | 32661 | AU |  |  |  |  | 116995 | US | 4084 | 8122800 | EU |  | 2060079 | AS |  |  |  |  | 1203500 | TH | 573
1033327 | 244564 | SCENT |  |  |  |  |  |  |  |  |  | 8087700 | EU | 21 | 2060080 | AS
1033330 | 244560 | SCENT |  |  |  |  |  |  |  |  |  | 8082900 | EU |  | 2060085 | AS |  | 9050110 | AF
1033330 | 262691 | SCENT |  |  |  |  |  |  | 115340 | US | 205
1033331 | 244561 | SCENT |  |  |  |  |  |  |  |  |  |  |  |  | 2060086 | AS
1033333 | 244546 | SCENT |  |  |  |  |  |  |  |  |  |  |  |  | 2060090 | AS
1033334 | 244557 | SCENT |  |  |  |  |  |  |  |  |  | 8084300 | EU |  | 2060091 | AS
1033339 | 304050 | SCENT |  |  |  |  |  |  |  |  |  | 8074000 | EU | 67 | 2060057 | AS |  |  |  |  | 1194400 | TH
1033344 | 231002 | PERSONAL |  |  |  |  |  |  |  |  |  | 8090600 | EU |  | 4060248 | AS
1033350 | 304051 | PAINT |  |  |  |  |  |  |  |  |  | 8082110 | EU | 17 |  | AS
1033356 | 304055 | PAINT |  |  |  |  |  |  |  |  |  | 8087430 | EU |  |  | AS