Spreadsheet: 828950d1683808469-using-lookup-and-if-in-one-formula-cds-import-descartes-worksheet
Sheet: Comm Codes

PREFERENCE | COMM CODE (SHORT) | COMM CODE | SUPP UNITS | TARIC CODES | NATIONAL CODES | SUPP UNITS | DOC CODE 1 | DOC REF 1 | DOC REASON 1 | DOC STATUS 1 | DOC CODE 2 | DOC REF 2 | DOC REASON 2 | DOC STATUS 2 | DOC CODE 3 | DOC REF 3 | DOC REASON 3 | DOC STATUS 3 | DOC CODE 4 | DOC REF 4 | DOC REASON 4 | DOC STATUS 4 | AI STATEMENT 1 | AI DESCRIPTION 1
300 | 16023985 | 1602398590 |  |  | VATZ |  | U110 | AUTH NO/REX |  | AE | 999L |  | [NAME]
100 | 25051000 | 2505100000 |  |  |  |  |  |  |  |  | Y923 |  | EXCLUDED PRODUCT
100 | 27073000 | 2707300090 |  |  | X520
300 | 27101221 | 2710122100 |  |  | X520 |  | U110 | AUTH NO/REX |  | AE
100 | 28030000 | 2803000000 |  |  |  |  |  |  |  |  | Y923 |  | EXCLUDED PRODUCT
300 | 32041700 | 3204170090 |  | 2701 |  |  | U110 | AUTH NO/REX TO AVOID 2701 ADDITIONAL CODE |  | AE | Y923 |  | EXCLUDED PRODUCT |  | Y930 |  | EXCLUDED REGULATION 2021/632
300 | 32061900 | 3206190090 |  |  |  |  |  |  |  |  | Y923 |  | EXCLUDED PRODUCT
300 | 32064970 | 3206497090 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y923 |  | EXCLUDED PRODUCT
300 | 32064970 | 3206497090 |  |  |  |  |  |  |  |  | Y923 |  | EXCLUDED PRODUCT
100 | 32081090 | 3208109000 |  | 4999 |  |  | U110 | AUTH NO/REX TO AVOID 4999 ADDITIONAL CODE |  | AE | Y923 |  | EXCLUDED PRODUCT
300 | 32082090 | 3208209000 |  | 4999 |  |  | U110 | AUTH NO/REX TO AVOID 4999 ADDITIONAL CODE |  | AE | Y923 |  | EXCLUDED PRODUCT
300 | 32089091 | 3208909100 |  | 4999 |  |  | U110 | AUTH NO/REX TO AVOID 4999 ADDITIONAL CODE |  | AE | Y923 |  | EXCLUDED PRODUCT
300 | 32089099 | 3208909900 |  | 4999 |  |  | U110 | AUTH NO/REX TO AVOID 4999 ADDITIONAL CODE |  | AE | Y923 |  | EXCLUDED PRODUCT
300 | 32091000 | 3209100000 |  | 4999 |  |  | U110 | AUTH NO/REX |  | AE | Y923 |  | EXCLUDED PRODUCT
300 | 32099000 | 3209900000 |  | 4999 |  |  | U110 | AUTH NO/REX TO AVOID 4999 ADDITIONAL CODE |  | AE | Y923 |  | EXCLUDED PRODUCT
300 | 32099000 | 3209900000 |  | 4999 |  |  | U110 | AUTH NO/REX |  | AE | Y923 |  | EXCLUDED PRODUCT
100 | 32100090 | 3210009000 |  | 4999 |  |  | U110 | AUTH NO/REX TO AVOID 4999 ADDITIONAL CODE |  | AE | Y923 |  | EXCLUDED PRODUCT
100 | 32129000 | 3212900000 |  | 4999 |  |  | U110 | AUTH NO/REX TO AVOID 4999 ADDITIONAL CODE |  | AE | Y923 |  | EXCLUDED PRODUCT
100 | 32131000 | 3213100000 |  |  |  |  |  |  |  |  | Y923 |  | EXCLUDED PRODUCT
300 | 32141010 | 3214101000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y926 |  | EXCLUDED FROM PROHIBITION
300 | 32149000 | 3214900000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 33049900 | 3304990000 |  |  |  |  |  |  |  |  | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 34011100 | 3401110000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y923 |  | EXCLUDED PRODUCT
100 | 34070000 | 3407000000
100 | 38140090 | 3814009099 |  |  | X520 |  |  |  |  |  | Y902 |  | NOT IN FOOTNOTE LIST |  | Y923 |  | EXCLUDED PRODUCT
300 | 38245090 | 3824509000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y923 |  | EXCLUDED PRODUCT
300 | 39172290 | 3917229090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39173900 | 3917390099 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39191080 | 3919108090 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y926 |  | EXCLUDED FROM PROHIBITION |  | 999L |  | [NAME]
100 | 39199080 | 3919908099 |  | 2701 |  |  | U110 | AUTH NO/REX TO AVOID 2701 ADDITIONAL CODE |  | AE | Y926 |  | EXCLUDED FROM PROHIBITION |  | 999L |  | [NAME]
300 | 39201024 | 3920102490 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39201040 | 3920104099 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39202029 | 3920202999 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39204310 | 3920431090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39221000 | 3922100000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39222000 | 3922200000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39229000 | 3922900000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 39232100 | 3923210000
100 | 39232990 | 3923299000 |  | 2601 |  |  | U110 | AUTH NO/REX TO AVOID 2601 ADDITIONAL CODE |  | AE
300 | 39249000 | 3924900090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39253000 | 3925300000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39259010 | 3925901000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 39259080 | 3925908000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 39262000 | 3926200000 |  | 2601 |  |  | U110 | AUTH NO/REX TO AVOID 2601 ADDITIONAL CODE |  | AE
300 | 39264000 | 3926400000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 39269097 | 3926909790 |  | 2601 |  |  | U110 | AUTH NO/REX TO AVOID 2601 ADDITIONAL CODE |  | AE | Y930 |  | EXCLUDED REGULATION 2021/632 |  | Y904 |  | NOT IN TR FOOTNOTE LIST
300 | 40169200 | 4016920000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 42022290 | 4202229090 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 42029211 | 4202921100 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 42029298 | 4202929890 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 42029900 | 4202990090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 44119490 | 4411949000 | [NAME] |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 44151010 | 4415101000 |  |  |  |  |  |  |  |  | Y900 |  | CITES PERMITS NOT REQUIRED
100 | 44160000 | 4416000000 |  |  |  |  |  |  |  |  | 999L |  | [NAME] |  |  |  |  |  |  |  |  |  | PAR11 | GOODS WERE TREATED TO PROCESS DESCRIBED IN TARIFF
100 | 44209099 | 4420909990 |  |  |  |  |  |  |  |  | Y900 |  | CITES PERMITS NOT REQUIRED
100 | 44209099 | 4420909990 |  |  |  |  |  |  |  |  | Y900 |  | CITES PERMITS NOT REQUIRED
100 | 44219999 | 4421999999 |  |  |  |  |  |  |  |  | Y904 |  | NOT IN TR FOOTNOTE LIST |  | Y900 |  | CITES PERMITS NOT REQUIRED
100 | 48062000 | 4806200000
100 | 48070080 | 4807008000
100 | 48081000 | 4808100000
100 | 48191000 | 4819100000
100 | 48191000 | 4819100000
100 | 48192000 | 4819200000
100 | 48193000 | 4819300000
100 | 48194000 | 4819400000
100 | 48195000 | 4819500000
100 | 48201030 | 4820103000
100 | 48201090 | 4820109000
100 | 48202000 | 4820200000
100 | 48203000 | 4820300000
100 | 48219010 | 4821901000
100 | 48236990 | 4823699000
100 | 48239085 | 4823908580 |  |  |  |  |  |  |  |  | Y923 |  | EXCLUDED PRODUCT
100 | 49011000 | 4901100000
100 | 49019900 | 4901990000
100 | 49019900 | 4901990000
100 | 49019900 | 4901990000
100 | 49089000 | 4908900000
100 | 49090000 | 4909000000
100 | 49111010 | 4911101000
100 | 49111090 | 4911109000
100 | 49119100 | 4911910090
100 | 49119900 | 4911990000
300 | 56075000 | 5607500099 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 58063210 | 5806321000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 59039099 | 5903909900 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 62092000 | 6209200090 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y032 |  | NOT CONTAINING SEAL PRODUCTS |  | Y922 |  | NO CAT OR DOG FUR
100 | 63062200 | 6306220000 |  | 2601 |  |  | U110 | AUTH NO/REX TO AVOID 2601 ADDITIONAL CODE |  | AE
300 | 63071010 | 6307101000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 63071090 | 6307109090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 63071090 | 6307109090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 66019990 | 6601999000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 68080000 | 6808000000
300 | 69101000 | 6910100000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y923 |  | EXCLUDED PRODUCT
100 | 69149000 | 6914900090 |  |  |  |  |  |  |  |  | Y923 |  | EXCLUDED PRODUCT |  | Y922 |  | NO CAT OR DOG FUR
100 | 70099100 | 7009910000
100 | 70099200 | 7009920000
300 | 70196600 | 7019660085 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 70196990 | 7019699085 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y923 |  | EXCLUDED PRODUCT
100 | 70199000 | 7019900085 |  | 2701 |  |  | U110 | AUTH NO/REX TO AVOID 2701 ADDITIONAL CODE |  | AE | Y923 |  | EXCLUDED PRODUCT
100 | 70200080 | 7020008000 |  |  |  |  |  |  |  |  | Y922 |  | NO CAT OR DOG FUR
300 | 71171900 | 7117190090 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y032 |  | NOT CONTAINING SEAL PRODUCTS |  | Y922 |  | NO CAT OR DOG FUR |  | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 71179000 | 7117900000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y032 |  | NOT CONTAINING SEAL PRODUCTS |  | Y922 |  | NO CAT OR DOG FUR |  | Y900 |  | CITES PERMITS NOT REQUIRED
100 | 73089000 | 7308900090
100 | 73151200 | 7315120000
100 | 73181535 | 7318153590
100 | 73181900 | 7318190090
100 | 73230000 | 7323000090 |  |  |  |  |  |  |  |  | Y923 |  | EXCLUDED PRODUCT
100 | 73239900 | 7323990090 |  |  |  |  |  |  |  |  | Y923 |  | EXCLUDED PRODUCT
100 | 73242900 | 7324290000
100 | 73249000 | 7324900090
100 | 73249000 | 7324900090
100 | 73269092 | 7326909290 |  | 2701 |  |  | U110 | AUTH NO/REX TO AVOID 2701 ADDITIONAL CODE |  | AE
300 | 73269098 | 7326909890 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y904 |  | NOT IN TR FOOTNOTE LIST
100 | 74182000 | 7418200090
300 | 76071111 | 7607111190 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 76152000 | 7615200000
100 | 82034000 | 8203400000
100 | 83024900 | 8302490099
100 | 83025000 | 8302500000
300 | 83059000 | 8305900000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 84281020 | 8428102000
100 | 84729080 | 8472908000
100 | 84798997 | 8479899790 |  |  |  |  |  |  |  |  | Y923 |  | EXCLUDED PRODUCT
300 | 84818011 | 8481801190 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 84818019 | 8481801990 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 84818059 | 8481805990 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 84819000 | 8481900090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 85051100 | 8505110099
100 | 85051990 | 8505199089
100 | 85122000 | 8512200090 |  | 2701 |  |  | U110 | AUTH NO/REX TO AVOID 2701 ADDITIONAL CODE |  | AE
300 | 85123090 | 8512309090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 85161011 | 8516101100 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 85286200 | 8528620000
100 | 85299092 | 8529909299
100 | 85312020 | 8531202090
100 | 85395100 | 8539510000 |  |  |  |  |  |  |  |  | Y924 |  | EXCLUDED FROM PROHIBITION |  | Y969 |  | REGULATION 2017/852 WAIVER
100 | 85437090 | 8543709099 |  | 2601~2701 |  |  | U110 | AUTH NO/REX TO AVOID 2601/2701 ADDITIONAL CODE |  | AE | Y904 |  | NOT IN TR FOOTNOTE LIST
100 | 85437090 | 8543709099 |  | 2601~2701 |  |  | U110 | AUTH NO/REX TO AVOID 2601/2701 ADDITIONAL CODE |  | AE | Y904 |  | NOT IN TR FOOTNOTE LIST
300 | 85442000 | 8544200090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 85444290 | 8544429090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 85447000 | 8544700090
300 | 87084099 | 8708409900 |  | 4999~2701 |  |  | U110 | AUTH NO/REX TO AVOID 4999/2701 ADDITIONAL CODE |  | AE
100 | 87089390 | 8708939090 |  | 4999 |  |  | U110 | AUTH NO/REX TO AVOID 4999 ADDITIONAL CODE |  | AE
300 | 90011010 | 9001101000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 90021100 | 9002110090
300 | 90178010 | 9017801000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 90230080 | 9023008000
100 | 90308900 | 9030890000
100 | 91021100 | 9102110000
100 | 92081000 | 9208100000 |  |  |  |  |  |  |  |  | Y900 |  | CITES PERMITS NOT REQUIRED
100 | 94036030 | 9403603000 |  |  |  |  |  |  |  |  | Y900 |  | CITES PERMITS NOT REQUIRED
100 | 94036090 | 9403609000 |  |  |  |  |  |  |  |  | Y900 |  | CITES PERMITS NOT REQUIRED
100 | 94036090 | 9403609000 |  |  |  |  |  |  |  |  | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 94038900 | 9403890090 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y904 |  | NOT IN TR FOOTNOTE LIST
300 | 94039100 | 9403910090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 94039910 | 9403991090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 94054990 | 9405499090 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 95030010 | 9503001000
300 | 95030021 | 9503002190 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y922 |  | NO CAT OR DOG FUR
100 | 95030029 | 9503002900 |  |  |  |  |  |  |  |  | Y922 |  | NO CAT OR DOG FUR
100 | 95030039 | 9503003990
100 | 95030049 | 9503004990 |  |  |  |  |  |  |  |  | Y922 |  | NO CAR OR DOG FUR
100 | 95030055 | 9503005590
100 | 95030061 | 9503006190
300 | 95030069 | 9503006900 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 95030070 | 9503007000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 95030095 | 9503009590 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y922 |  | NO CAT OR DOG FUR
300 | 95030095 | 9503009590 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y922 |  | NO CAT OR DOG FUR
100 | 95030099 | 9503009990 |  |  |  |  |  |  |  |  | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 95044000 | 9504400000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 95049080 | 9504908000 |  |  |  |  |  |  |  |  | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 95059000 | 9505900000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y922 |  | NO CAT OR DOG FUR |  | Y926 |  | EXCLUDED FROM PROHIBITIOIN
300 | 95059000 | 9505900000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y922 |  | NO CAT OR DOG FUR |  | Y926 |  | EXCLUDED FROM PROHIBITION
300 | 95066200 | 9506620000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
300 | 95069190 | 9506919000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y922 |  | NO CAT OR DOG FUR
300 | 95069990 | 9506999000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y922 |  | NO CAT OR DOG FUR
100 | 95082900 | 9508290000 |  |  |  |  |  |  |  |  | Y922 |  | NO CAT OR DOG FUR |  | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 96081010 | 9608101000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 96082000 | 9608200000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 96085000 | 9608500000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 96089900 | 9608990000 |  |  |  |  | U110 | AUTH NO/REX |  | AE | Y900 |  | CITES PERMITS NOT REQUIRED
300 | 96091090 | 9609109000 |  |  |  |  | U110 | AUTH NO/REX |  | AE
100 | 96099090 | 9609909000
100 | 96122000 | 9612200000