Spreadsheet: 743422d1628494690-filter-function-not-returning-multple-values-examplefilter
Sheet: PackingSlips_V2

KeycodeImported | NAME1B | NAME1 | NAME1_GIFT1 | NAME1_GIFT2 | NAME1_GIFT3 | NAME1_GIFT4 | NAME1_GIFT5 | NAME1_GIFT6 | NAME2 | NAME2_GIFT1 | NAME2_GIFT2 | NAME2_GIFT3 | NAME2_GIFT4 | NAME2_GIFT5 | NAME2_GIFT6 | NAME3 | NAME3_GIFT1 | NAME3_GIFT2 | NAME3_GIFT3 | NAME3_GIFT4 | NAME3_GIFT5 | [NAME] | COMPANY | [NAME] | ADD2 | CITY | PROV | PC | PROD_code | SKU | PIECE_NO | PROD_NAME | COUNTRY | UniqueCode | PrintSeqPS | PrintSeqInd | GiftNo | NAME1A | KEYCODE_NAME
M23740-2-092 | DUCHESNEAU MARISSA | DUCHESNEAU MARISSA |  |  |  |  |  |  | LEFRANCOIS EMILIE |  |  |  |  |  |  |  |  |  |  |  |  |  | BRUNET #15944 | 101-1451 RUE DE L'ETNA |  | QUEBEC | QC | [NAME] | M9155001 • IDEAL SOLEIL SPF 60 SPORT | M9155001 | P04 | IDEAL SOLEIL SPF 60 SPORT | CA | [NAME] #[PHONE] RUE DE L'ETNA | 092 | 94 | P04 | COSMETIC MANAGER AND TEAM/CHEF COSMETICIENNE ET EQUIPE | M23740-2-092DUCHESNEAU MARISSA
M23740-3-155 | CHAN WENDY | CHAN WENDY |  |  |  |  |  |  | LIANG FRANNY |  |  |  |  |  |  | LOCH ALISA |  |  |  |  |  |  | SHOPPERS DRUG MART#2234 | 3277 CAMBIE ST |  | [NAME] | BC | V5Z 2W3 | [PHONE] • ADVANCED GENIFIQUE 30ML | 3614272623545 | P03 | ADVANCED GENIFIQUE 30ML | CA | V5Z 2W3SHOPPERS DRUG MART#22343277 CAMBIE ST | 155 | 244 | P03 | COSMETIC MANAGER AND TEAM/CHEF COSMETICIENNE ET EQUIPE | M23740-3-155CHAN WENDY
M23740-13-185 | BELL LAURIE-LOU | BELL LAURIE-LOU |  | P07 | P12 |  |  |  | GIRARD [NAME] |  |  |  |  |  |  | LALONDE-SAINT-CYR ELOISE |  | P07 | P08 | P10 |  |  | PHCIE J.COUTU #346 | 2545 [NAME] |  | BOISBRIAND | QC | [NAME] | [PHONE] • ADVANCED GENIFIQUE 30ML | 3614272623545 | P03 | ADVANCED GENIFIQUE 30ML | CA | J7H 0C2PHCIE J.COUTU #3462545 [NAME] | 185 | 393 | P03 | COSMETIC MANAGER AND TEAM/CHEF COSMETICIENNE ET EQUIPE | M23740-13-185BELL LAURIE-LOU
What I want to do:
KeycodeImported | NAME1B | NAME1 | NAME1_GIFT1 | NAME1_GIFT2 | NAME1_GIFT3 | NAME1_GIFT4 | NAME1_GIFT5 | NAME1_GIFT6 | NAME2 | NAME2_GIFT1 | NAME2_GIFT2 | NAME2_GIFT3 | NAME2_GIFT4 | NAME2_GIFT5 | NAME2_GIFT6 | NAME3 | NAME3_GIFT1 | NAME3_GIFT2 | NAME3_GIFT3 | NAME3_GIFT4 | NAME3_GIFT5 | [NAME] | COMPANY | [NAME] | ADD2 | CITY | PROV | PC | PROD_code | SKU | PIECE_NO | PROD_NAME | COUNTRY | UniqueCode | PrintSeqPS | PrintSeqInd | GiftNo | NAME1A | KEYCODE_NAME
M23740-2-092 | DUCHESNEAU MARISSA | DUCHESNEAU MARISSA |  |  |  |  |  |  | LEFRANCOIS EMILIE |  |  |  |  |  |  |  |  |  |  |  |  |  | BRUNET #15944 | 101-1451 RUE DE L'ETNA |  | QUEBEC | QC | [NAME] | M9155001 • IDEAL SOLEIL SPF 60 SPORT | M9155001 | P04 | IDEAL SOLEIL SPF 60 SPORT | CA | [NAME] #[PHONE] RUE DE L'ETNA | 092 | 94 | P04 | COSMETIC MANAGER AND TEAM/CHEF COSMETICIENNE ET EQUIPE | M23740-2-092DUCHESNEAU MARISSA
M23740-3-155 | CHAN WENDY | CHAN WENDY |  |  |  |  |  |  | LIANG FRANNY |  |  |  |  |  |  | LOCH ALISA |  |  |  |  |  |  | SHOPPERS DRUG MART#2234 | 3277 CAMBIE ST |  | [NAME] | BC | V5Z 2W3 | [PHONE] • ADVANCED GENIFIQUE 30ML | 3614272623545 | P03 | ADVANCED GENIFIQUE 30ML | CA | V5Z 2W3SHOPPERS DRUG MART#22343277 CAMBIE ST | 155 | 244 | P03 | COSMETIC MANAGER AND TEAM/CHEF COSMETICIENNE ET EQUIPE | M23740-3-155CHAN WENDY
M23740-13-185 | BELL LAURIE-LOU | BELL LAURIE-LOU |  | P07 | P12 |  |  |  | GIRARD [NAME] |  |  |  |  |  |  | LALONDE-SAINT-CYR ELOISE |  | P07 | P08 | P10 |  |  | PHCIE J.COUTU #346 | 2545 [NAME] |  | BOISBRIAND | QC | [NAME] | [PHONE] • ADVANCED GENIFIQUE 30ML | 3614272623545 | P03 | ADVANCED GENIFIQUE 30ML | CA | J7H 0C2PHCIE J.COUTU #3462545 [NAME] | 185 | 393 | P03 | COSMETIC MANAGER AND TEAM/CHEF COSMETICIENNE ET EQUIPE | M23740-13-185BELL LAURIE-LOU