Spreadsheet: 841808d1693963741-nested-if-formula-with-an-error-testworkbook
Sheet: PLE Data

IMPOS Name |  |  |  |  |  |  |  | SKU Name | PLE Code
Bt PLE N/V Spark. V21 | CHS 21 |  |  |  |  | PLE - Online |  | PLE C/SKIN CHARDONNAY 2020 | CH 20 CS
Bt PLE P.Gris 19 | PG 19 |  |  |  |  | PLE - T/A |  | PLE C/SKIN PINOT GRIS 2019 | PG 19 CS
Bt PLE P.Noir 18 | PN 18 |  |  |  |  | PLE Packs |  | PLE C/SKIN PINOT NOIR 2009 | PN 09 CS
O/L PLE Reserve P. Noir 2018 | PN 18 RES |  |  |  |  | PLE - W/C |  | PLE C/SKIN PINOT NOIR 2020 | PN 20 CS
Bt PLE Rose 21 | RO 21 |  |  |  |  | PLE - Glass |  | PLE CHARDONNAY 2012 | CH 12
T/A Bt PLE N/V Spark. V21 | CHS 21 |  |  |  |  | PLE - Bottle |  | PLE CHARDONNAY 2013 | CH 13
T/A PLE Reserve Chard. 18 | CH 18 RES |  |  | Cellar Door |  |  |  | PLE CHARDONNAY 2014 | CH 14
T/A Bt PLE Chard. 19 | CH 19 |  |  |  |  |  |  | PLE CHARDONNAY 2015 | CH 15
T/A Bt PLE P.Noir 19 | PN 19 |  |  |  |  |  |  | PLE CHARDONNAY 2016 | CH 16
T/A Bt PLE Shiraz 19 | SH 19 |  |  |  |  | Doshii |  | PLE CHARDONNAY 2017 | CH 17
Bt PLE Chard. 19 | CH 19 |  |  |  |  |  |  | PLE CHARDONNAY 2018 | CH 18
Bt PLE P.Noir 19 | PN 19 |  |  |  |  |  |  | PLE CHARDONNAY 2019 | CH 19
Gl PLE Method Traditionelle 2018 | MTS 18 |  |  |  |  |  |  | PLE CHARDONNAY 2020 | CH 20
Gl PLE Chard. 19 | CH 19 |  |  |  |  |  |  | PLE CHARDONNAY 2021 | CH 21
Gl PLE Reserve PN 18 | PN 18 RES |  |  |  |  |  |  | PLE CHARDONNAY RESERVE 2018 | CH 18 RES
Gl PLE Rose 21 | RO 21 |  |  |  |  |  |  | PLE CHARDONNAY RESERVE 2019 | CH 19 RES
Gl PLE [NAME] 19 | SH 19 |  |  |  |  |  |  | PLE CHARDONNAY RESERVE 2020 | CH 20 RES
Gl PLE P.Noir 19 | PN 19 |  |  |  |  |  |  | PLE CHARDONNAY RESERVE 2021 | CH 21 RES
O/L Bt PLE P.Noir 17 | PN 17 |  |  |  |  |  |  | PLE PINOT GRIS 2018 | PG 18
O/L Bt PLE P.Noir 18 | PN 18 |  |  |  |  |  |  | PLE PINOT GRIS 2019 | PG 19
O/L BYO - PLE Pinot Noir 2019 | PN 19 |  |  |  |  |  |  | PLE PINOT GRIS 2020 | PG 20
O/L PLE Reserve P. Noir 2019 | PN 19 RES |  |  |  |  |  |  | PLE PINOT GRIS 2021 | PG 21
T/A Bt PLE P.Noir 10 | PN 10 |  |  |  |  |  |  | PLE PINOT NOIR 2010 | PN 10
T/A Bt PLE Rose 21 | RO 21 |  |  |  |  |  |  | PLE PINOT NOIR 2013 | PN 13
Premium Pinot Noir Pack |  |  |  |  |  |  |  | PLE Pinot Noir 2015 | PN 15
Gl PLE P.Gris 19 | PG 19 |  |  |  |  |  |  | PLE PINOT NOIR 2016 | PN 16
T/A Bt PLE P.Gris 18 | PG 18 |  |  |  |  |  |  | PLE PINOT NOIR 2017 | PN 17
T/A Bt PLE P.Noir 18 | PN 18 |  |  |  |  |  |  | PLE PINOT NOIR 2018 | PN 18
T/A PLE Reserve Chard. 19 | CH 19 RES |  |  |  |  |  |  | PLE PINOT NOIR 2018 2 FRIENDS | PN 18 2F
T/A PLE Reserve P.Noir 19 | PN 19 RES |  |  |  |  |  |  | PLE PINOT NOIR 2019 | PN 19
Gl PLE N/V Spark. V21 | CHS 21 |  |  |  |  |  |  | PLE PINOT NOIR 2020 | PN 20
T/A Bt PLE P.Gris 21 | PG 21 |  |  |  |  |  |  | PLE PINOT NOIR 2021 | PN 21
T/A PLE Reserve P.Noir 18 | PN 18 RES |  |  |  |  |  |  | PLE PINOT NOIR RESERVE 2018 | PN 18 RES
[NAME] Rose 2021 | RO 21 |  |  |  |  |  |  | PLE PINOT NOIR RESERVE 2019 | PN 19 RES
Gl PLE Reserve Chard.18 | CH 18 RES |  |  |  |  |  |  | PLE PINOT NOIR RESERVE 2020 | PN 20 RES
O/L Bt PLE Chard. 17 | CH 17 |  |  |  |  |  |  | PLE PINOT NOIR RESERVE 2021 | PN 21 RES
O/L Bt PLE P.Noir 19 | PN 19 |  |  |  |  |  |  | PLE ROSE 2022 | RO 22
T/A Bt PLE P.Noir 17 | PN 17 |  |  |  |  |  |  | PLE ROSE 2021 | RO 21
Freight |  |  |  |  |  |  |  | PLE SHIRAZ 2010 | SH 10
T/A Bt PLE Chard. 18 | CH 18 |  |  |  |  |  |  | PLE SHIRAZ 2011 | SH 11
W/C Bt Res P.Noir 19 | PN 19 RES |  |  |  |  |  |  | PLE SHIRAZ 2012 | SH 12
Gl PLE Chard. 18 | CH 18 |  |  |  |  |  |  | PLE SHIRAZ 2015 | SH 15
Gl PLE Reserve PN 19 | PN 19 RES |  |  |  |  |  |  | PLE SHIRAZ 2016 | SH 16
T/A Bt PLE Shiraz 12 | SH 12 |  |  |  |  |  |  | PLE SHIRAZ 2018 | SH 18
Gl PLE P.Noir 18 | PN 18 |  |  |  |  |  |  | PLE SHIRAZ 2019 | SH 19
T/A Bt PLE 2018 Spark. | MTS 18 |  |  |  |  |  |  | PLE SHIRAZ 2020 2 FRIENDS | SH 20 2F
T/A Bt PLE P.Gris 19 | PG 19 |  |  |  |  |  |  | PLE Sparkling Charmat (2021) | CHS 21
Bt PLE P.Noir 17 | PN 17 |  |  |  |  |  |  | PLE SPARKLING METHOD TRADITIONAL 2018 | MTS 18
Bt PLE Reserve P.Noir 18 | PN 18 RES |  |  |  |  |  |  | PLE PINOT GRIS 2009 | PG 09
Crf PLE PN 2019 | PN 19 |  |  |  |  |  |  | PLE PINOT GRIS 2010 | PG 10
Crf PLE CH 2019 | CH 19 |  |  |  |  |  |  | PLE PINOT GRIS 2016 | PG 16
Gl 2 Friends [NAME] 20 | SH 20 2F |  |  |  |  |  |  | PLE SHIRAZ 2009 | SH 09
Three Pack #1 |  |  |  |  |  |  |  | PLE SHIRAZ 2014 | SH 14
[NAME] 19 | PG 19 |  |  |  |  |  |  | PLE ROSE 2019 | RO 19
PLE P.Noir 19 | PN 19 |  |  |  |  |  |  | PLE SHIRAZ 2017 | SH 17
PLE Rose 2021 | RO 21 |  |  |  |  |  |  | PLE C/SKIN SHIRAZ 2020 | SH 20 CS
Gl PLE Reserve Chard. 19 | CH 19 RES |  |  |  |  |  |  | PLE  CHARDONNAY RESERVE 2020 | CH 20 RES
Bt PLE P.Noir 13 | PN 13 |  |  |  |  |  |  | PLE CLEARANCE SHIRAZ 2020 2 FRIENDS | SH 20 2F
Bt PLE Chard. 13 | CH 13 |  |  |  |  |  |  | PLE SHIRAZ  2019 | SH 19
Twin Pack #1 |  |  |  |  |  |  |  | PLE PINOT NOIR 2022 | PN 22
W/C Bt P.Gris 18 | PG 18 |  |  |  |  |  |  | PLE CHARDONNAY 2022 | CH 22
W/C Bt P.Noir 19 | PN 19 |  |  |  |  |  |  | PLE PINOT NOIR 2009 C/S | PN 09 CS
W/C Bt P.Noir 18 | PN 18 |  |  |  |  |  |  | PLE SHIRAZ 2021 | SH 21
T/A Bt 2 Friends [NAME] 20 | SH 20 2F
T/A Bt PLE Shiraz 11 | SH 11
Crf PLE SH 2019 | SH 19
Bt PLE Methode Traditionelle 2018 | MTS 18
O/L Bt PLE Shiraz 19 | SH 19
Bt 2 Friends [NAME] 20 | SH 20 2F
Bt PLE P.Gris 18 | PG 18
O/L Bt PLE 2018 Spark. | MTS 18
O/L Bt PLE N/V Sparking 2021 | CHS 21
O/L Bt PLE P.Gris 19 | PG 19
O/L Bt PLE P.Gris 20 | PG 20
O/L Bt PLE Rose 21 | RO 21
O/L Bt PLE Shiraz 19 | SH 19
PLE Chard. 18 | CH 18
PLE M/T Spark. 18 | MTS 18
PLE P.Noir 18 | PN 18
PLE Res Chard. 19 | CH 19 RES
PLE Res P.Noir 19 | PN 19 RES
PLE Chard. 19 | CH 19
PLE NV Sparkling 2021 | CHS 21
PLE NV Spark 2021 | CHS 21
PLE P.Gris 19 | PG 19
PLE P.Noir 19 | PN 19
PLE Rose 21 | RO 21
[NAME] | CHS 21
PLE Bishop Cocktail | PN 19
[NAME] | CHS 21
[NAME] | CHS 21
Amaro [NAME] | CHS 21
2018 2 Friends Pinot Noir | PN 18 2F
2018 Estate Pinot Gris | PG 18
2020 [NAME] | CH 20 CS
2020 Cleanskin Pinot Noir | PN 20 CS
[NAME] | MTS 18
PLE Pinot 2013 Flight | PN 13
PLE Chard 2013 Flight | CH 13
Twin Pack #3
T/A Bt PLE Chard. 17 | CH 17
Bt PLE Reserve Chard. 18 | CH 18 RES
[NAME] 2019 | PG 19
Bt PLE 2018 Spark. | MTS 18
Bt PLE Shiraz 19 | SH 19
Bt PLE Chard. 18 | CH 18
T/A Bt PLE [NAME] 15 | SH 15
W/C Bt Res Chard. 19 | CH 19 RES
W/C Bt Chard. 18 | CH 18
W/C Bt N/V Spark. V21 | CHS 21
Cuvee Chocolate
FD Gentlemans Hamper
W/C Bt Chard. 19 | CH 19
Bt PLE Reserve Chard. 19 | CH 19 RES
T/A Bt PLE Chard. 14 | CH 14
T/A Bt PLE Chard. 13 | CH 13
Bt PLE Chard. 15 | CH 15
Crf PLE PN Reserve 2018 | PN 18 RES
Crf PLE Reserve CH 2018 | CH 18 RES
T/A Bt PLE Shiraz 10 | SH 10
Bt PLE Chard. 17 | CH 17
Crf PLE PN Reserve 2018 | PN 18 RES
2020 2 Friends [NAME] | SH 20 2F
W/C Bt Res. Chard. 18 | CH 18 RES
W/C Bt Rose 21 | RO 21
W/C Bt Shiraz 12 | SH 12
T/A Bt PLE Chard. 16 | CH 16
Bt PLE Shiraz 12 | SH 12
W/C Bt P.Gris 19 | PG 19
W/C Bt P.Noir 17 | PN 17
Bt PLE P.Gris 21 | PG 21
Caviar Bump & Glass Methode | MTS 18
Bt PLE Shiraz 11 | SH 11
O/L PLE Reserve Chard 2019 | CH 19 RES
PLE Sculpture Puzzle | Packs
W/C Bt Chard. 17 | CH 17
W/C Bt Shiraz 19 | SH 19
Bt Two Friends P.Noir 18 | PN 18 2F
T/A Bt Two Friends P.Noir 18 | PN 18 2F
Six Pack #2 | Packs
O/L Bt PLE Shiraz 11 | SH 11
O/L Bt PLE P.Gris 21 | PG 21
Bt PLE Reserve P.Noir 19 | PN 19 RES
Bt PLE Chard. 12 | CH 12
Bt PLE Chard. 16 | CH 16
Gl PLE P.Noir 17 | PN 17
T/A Bt PLE Rose 20 | RO 20
O/L Bt PLE Chard. 19 | CH 19
W/C Bt M/T 18 Spark. | MTS 18
O/L Bt PLE Chard. 13 | CH 13
O/L Bt 2 Friends [NAME] 20 | SH 20 2F
O/L Bt PLE Shiraz 12 | SH 12
O/L Bt 2 Friends [NAME] 20 | SH 20 2F
O/L Bt PLE Shiraz 12 | SH 12
Three Pack #2
Gl PLE Pinot Noir 2013 | PN 13
Gl PLE Chard 2013 | CH 13
W/C Tea Towel - Black
T/A Bt PLE Chard. 15 | CH 15
[NAME] | MTS 18
St Felix Bitter Citrus | MTS 18
St Felix Flight | MTS 18
T/A Bt PLE [NAME] 18 | SH 18
$60 Beverage Package
Six Pack #1
Bt PLE Chard. 14 | CH 14
W/C Bt Res. P.Noir 18 | PN 18 RES
O/L Twin Pack - Chard & Pinot
Six Pack #1
Bt PLE P.Gris 20 | PG 20
Bt PLE Shiraz 10 | SH 10
O/L Twin Pack - Chard & Pinot
Bt PLE Shiraz 15 | SH 15
Gl PLE Pinot Noir 2017 | PN 17
T/A Bt PLE P.Noir 13 | PN 13
T/A Bt PLE Rose 22 | RO 22
W/C Bt Shiraz 2011 | SH 11
Gl PLE N/V Spark | CHS 21
O/L PLE Reserve Chard 2018 | CH 18 RES
O/L The Entertainer
O/L The Peninsula Celebration
O/L Wine & Wind Down
O/L Six Pack - Gris Rose Chard
BYO PLE [NAME]
The Peninsula Celebration
O/L Festive Mixed 22
O/L Festive Red 22
O/L Festive Three 22
O/L Festive White 22
Open PLE Beverage
T/A Bt PLE 2018 MT Spark. | MTS 18
O/L Bt PLE Chard. 16 | CH 16
B & H Nougat
Wine & Wind Down
The Peninsula Celebration
2021 Pinot Gris | PG 21
W/C Bt P.Gris 20 | PG 20
O/L Bt PLE N/V Spark. 21 | CHS 21
O/L Cape Schanck Olive Oil 3 Pack
O/L Olieve & Olie Soy Olive Oil Candle
O/L Peninsula Nut Co. - Almonds
O/L PLE Apron
O/L The Entertainer
Twin Pack #3
O/L Bt PLE [NAME] 10 | SH 10
O/L Six Pack - Spark Rose Pinot
O/L Twin Pack - Spark & Gris
O/L Bt PLE Chard. 18 | CH 18
W/C Bt Shiraz 2 Friends 20 | SH 20 2F
O/L Twin Pack - Gris and [NAME]
T/A Bt PLE P.Noir 15 | PN 15
T/A Bt PLE P.Noir 20 | PN 20
T/A Bt PLE P.Noir 21 | PN 21
PLE P.Noir 13 | PN 13
PLE P.Noir 15 | PN 15
PLE P.Noir 17 | PN 17
PLE P.Noir 20 | PN 20
PLE P.Noir 21 | PN 21
PLE Res P.Noir 18 | PN 18 RES
PLE Res P.Noir 19 | PN 19 RES
Old Cuban | CHS 21
O/L Cuvee Chocolate
O/L Olieve & Olie Wash & Cream Set
Peninsula Nut Co. - Almonds
The Entertainer
W/C Bt Res P.Noir 20 | PN 20 RES
O/L Three Pack - Gris Rose Pinot
O/L Bt PLE [NAME] 15 | SH 15
T/A Bt PLE N/V Spark. | SH 15
BYO - Build Your Own Hamper
BYO Peninsula Nut Co.
PLE NV Brut | CHS 21
PLE Rose 20 | RO 20
Bt PLE N/V Spark. | CHS 21
Farm Goat Soap
PHS [NAME]
PLE Wine & Wellness Hamper
Red Hill Candle
Taralinga Dark Chocolate EVOO
W/C Bt N/V Spark. | CHS 21
Three Pack #3
PLE M/T Sparkling | MTS 18
Gl PLE Rose 20 | RO 20
BYO B & H Nougat
BYO Lakrids by [NAME]
BYO Taralinga Dark Chocolate
T/A Bt PLE Rose 19 | RO 19
BYO Icky Sticky Date Pudding
Twin Pack #2
W/C Six Pack #2
W/C Three Pack #1
BYO PHS [NAME]
BYO Sculpture Park Puzzle
W/C Bt Chard. 16 | CH 16
Icky Sticky Pudding
Mumma Made Jam
Mumma Made Mustard
PLE Cocktail
PLE Peninsula Hamper
Taralinga olive Oil
Gl PLE Chard. 17 | CH 17
Festive Three Pack #1
[NAME] 18 | PG 18
PLE Rose 19 | RO 19
BYO PLE Cocktail
BYO Mumma Made Mustard
BYO Red Hill Candle
Lakrids by Bulow
Peninsula Nut Co.
PLE [NAME]
Riedel PLE Flutes
Festive Twin Pack #1 PG.Ro
PLE Art Appreciation Hamper
PLE [NAME]
Bt PLE Shiraz 18 | SH 18
Bt PLE Chard. 11 | CH 11
[NAME] 22 - Luxe Entertainer
[NAME] 22 - Peninsula Celebration
$65 Group Beverage
$65 Group Beverage
O/L Three Pack-Spark Chard Pinot
T/A Bt PLE [NAME] 14 | SH 14
$65 Group Beverage
T/A Bt PLE [NAME] 14 | SH 14
$65 Group Beverage
$65 Group Beverage
$65 Group Beverage
T/A Bt PLE [NAME] 16 | SH 16
Gl PLE CS Chard. 20 | CH 20 CS
Bt PLE CS Chard 20 | CH 20 CS
Bt PLE CS P.Gris 19 | PG 19 CS
Bt PLE CS P.Noir 20 | PN 20 CS
Gl PLE CS P.Noir 20 | PN 20 CS
Gl PLE CS P.Gris 19 | PG 19 CS
T/A Bt C/S Chard. 20 | CH 20 CS
W/C Bt Chard. 13 | CH 13
W/C Bt Shiraz 10 | SH 10
T/A Bt PLE CS P.Gris 19 | PG 19 CS
T/A Bt PLE CS P.Noir 20 | PN 20 CS
T/A Bt PLE CS Chard 20 | CH 20 CS
[NAME] 2020 | PG 20
Gl PLE P.Gris 20 | PG 20
Gl PLE Chard. 16 | CH 16
O/L Bt PLE CS Chard 20 | CH 20 CS
O/L Bt PLE CS P.Noir 20 | PN 20 CS
O/L PLE Vespa Martini Cocktail
T/A Bt PLE P.Gris 20 | PG 20
O/L Harvest Mixed 23
O/L Harvest Red 23
O/L Harvest Three 23
O/L Harvest White 23
O/L Bt PLE Chard. 14 | CH 14
O/L Bt PLE P.Noir 15 | PN 15
O/L Bt PLE [NAME] 17 | SH 17
O/L 5-Year Celebration 3-Pack
O/L 5-Year Celebration Pack
W/C Twin Pack #2
T/A Harvest Red 23
Gl PLE Chard. 14 | CH 14
T/A Bt PLE P.Gris 16 | PG 16
Gl PLE Rose 22 | RO 22
O/L Indulge Mum Hamper
Riedel PLE Flute - Pair
[NAME]
O/L Indulge Mum Hamper
Spoil [NAME]
Negroni Sbagliato | CHS 21
T/A Bt PLE CS Shiraz 20 | SH 20 CS
T/A Bt PLE Shiraz 17 | SH 17
W/C Twin Pack #3
O/L Spoil [NAME]
PLE [NAME] 19 | SH 19
PLE [NAME] 17 | SH 17
PLE [NAME] 2020 2F | SH 20 2F
PLE 2F Shiraz 20
Marias Special | CHS 21
Gl PLE [NAME] 17 | SH 17
O/L Bt PLE CS Shiraz 20 | SH 20 CS
Bt PLE Shiraz 17 | SH 17
O/L Treat Mum Hamper
PLE Methode Traditional 75ml 2018 | MTS 18
PLE Chardonnay Flight 2016 | CH 16
PLE Methode Traditional 75ml 2018 | MTS 18
W/C Bt Shiraz 17 | SH 17
W/C Bt Rose 22 | RO 22
Warm Spiced Pinot Noir Cocktail | PN 19
Bt PLE P.Noir 09 | PN 09 CS
LB Special | CHS 21
PLE P.Gris 20 | PG 20
PLE  Bt P.Gris 20 | PG 20