Spreadsheet: 164981d1340977826-clear-2-ranges-of-cell-data-when-value-is-changed-in-primary-drop-down-no-programming-development_swing-ticket-20120628-beta
Sheet: 69LSizeChart

 | SizeChart |  |  | Pantone |  | ST/L2101OT (Single Colour Size Block) |  |  |  |  | ST/L2107OT (Dual Colour Size Block) |  |  |  | ST/A2222OM (Quad Colour Size Block - not exist)
1 | ST/L2101OT | STL2101OTPriSize | STL2101OTSecSize | STL2101OTPantone |  | Primary [NAME] |  | Secondary [NAME] |  |  | Primary [NAME] |  | Secondary [NAME] |  | Primary [NAME] |  | Secondary [NAME]
2 | ST/L2107OT | STL2107OTPriSize | STL2107OTSecSize | STL2107OTPantone |  | Dress Size | Pantone Code | Lengths | Pantone Code |  | Dress Size | Pantone Code | Lengths | Pantone Code | [NAME] | Pantone Code | Lengths | Pantone Code
3 |  | PriSize | SecSize | Pantone |  | 2 | 203C | X SHORT | DNP | Secondary [NAME] | 4-6 | 366C / 134C | 29cm - 111/2in | DNP | 1 | 203C | X SHORTb | DNP
4 |  |  |  |  |  | 4 | 366C | SHORT | DNP | Secondary [NAME] | 6-8 | 134C / 2716C | 36cm - 14in | DNP | 2 | 366C | SHORTb | DNP
5 |  |  |  |  |  | 6 | 134C | SHORT FIT | DNP | Secondary [NAME] | 8-10 | 2716C / 1485C | 38cm - 15in | DNP | 3 | 134C | SHORT FITb | DNP
6 |  |  |  |  |  | 8 | 2716C | SHORT FITTING | DNP | Secondary [NAME] | 10-12 | 1485C / 367C | 41cm - 16in | DNP | 4 | 2716C | SHORT FITTINGb | DNP
7 |  |  |  |  |  | 10 | 1485C | PETITE | DNP | Secondary [NAME] | 12-14 | 367C / 319C | 43cm - 17in | DNP | 5 | 1485C | PETITEb | DNP
8 |  |  |  |  |  | 12 | 367C | CROPPED | DNP | Secondary [NAME] | 14-16 | 319C / 115C | 46cm - 18in | DNP | 6 | 367C | CROPPEDb | DNP
9 |  |  |  |  |  | 14 | 319C | MEDIUM | DNP | Secondary [NAME] | 16-18 | 115C / 198C | 48cm - 19in | DNP | 7 | 319C | MEDIUMb | DNP
10 |  |  |  |  |  | 16 | 115C | MIDI | DNP | Secondary [NAME] | 18-20 | 198C / Cool Gray 5C | 50cm - 191/2in | DNP | 8 | 115C | MIDIb | DNP
11 |  |  |  |  |  | 18 | 198C | MINI | DNP | Secondary [NAME] | 20-22 | Cool Gray 5C / 687C | 51cm - 20in | DNP | 9 | 198C | MINIb | DNP
12 |  |  |  |  |  | 20 | [NAME] | STANDARD | DNP | Secondary [NAME] | 22-24 | 687C / 143C | 53cm - 21in | DNP | 10 | [NAME] | STANDARDa | DNP
13 |  |  |  |  |  | 22 | 687C | STANDARD FIT | DNP | Secondary [NAME] | 24-26 | 143C / 337C | 54cm - 211/4in | DNP | 11 | 687C | STANDARD FITb | DNP
14 |  |  |  |  |  | 24 | 143C | LONG | DNP | Secondary [NAME] | 26-28 | 337C / 292C | 56cm - 22in | DNP | 12 | 143C | LONGb | DNP
15 |  |  |  |  |  | 26 | 337C | LONG FIT | DNP | Secondary [NAME] | 28-30 | 292C / 702C | 58cm - 23in | DNP | 13 | 337C | LONG FITb | DNP
16 |  |  |  |  |  | 28 | 292C | X LONG | DNP | Secondary [NAME] | 30-32 | 702C / 480C | 60cm - 231/2in | DNP | 14 | 292C | X LONGb | DNP
17 |  |  |  |  |  | 30 | 702C | XX LONG | DNP | Secondary [NAME] |  |  | 61cm - 24in | DNP | 15 | 702C | XX LONGb | DNP
18 |  |  |  |  |  | 32 | 480C | SHORT/MEDIUM | DNP | Secondary [NAME] |  |  | 64cm - 25in | DNP | 16 | 480C | SHORT/MEDIUMb | DNP
19 |  |  |  |  |  |  |  | MEDIUM/LONG | DNP | Secondary [NAME] |  |  | 66cm - 26in | DNP |  |  | MEDIUM/LONGb | DNP
20 |  |  |  |  |  |  |  | LONG/X LONG | DNP | Secondary [NAME] |  |  | 69cm - 27in | DNP |  |  | LONG/X LONGb | DNP
21 |  |  |  |  |  |  |  |  |  |  |  |  | 71cm - 28in | DNP
22 |  |  |  |  |  |  |  |  |  |  |  |  | 72cm - 281/2in | DNP
23 |  |  |  |  |  |  |  |  |  |  |  |  | 74cm - 29in | DNP
24 |  |  |  |  |  |  |  |  |  |  |  |  | 76cm - 30in | DNP
25 |  |  |  |  |  |  |  |  |  |  |  |  | 78cm - 301/2in | DNP
26 | Remarks: GIVEN RANGE NAME FOR Primary [NAME] |  | Remarks: GIVEN RANGE NAME FOR lookup Pantone Code |  |  |  |  |  |  |  |  |  | 79cm - 31in | DNP
#N/A | G4:G19 | STL2101OTPriSize | H4:IH9 | STL2101OT |  |  |  |  |  |  |  |  | 81cm - 32in | DNP
#N/A | L4:L17 | STL2107OTPriSize | M4:[NAME] | STL2107OT |  |  |  |  |  |  |  |  | 84cm - 33in | DNP
#N/A | O4:O19 | STA2222OMPriSize | O4:P19 | STA2222OT |  |  |  |  |  |  |  |  | 86cm - 34in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 89cm - 35in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 90cm - 351/2in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 91cm - 36in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 94cm - 37in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 97cm - 38in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 98cm - 381/2in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 99cm - 39in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 104cm - 41in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 110cm - 431/4in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 116cm - 451/2in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 122cm - 48in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 128cm - 501/2in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 134cm - 523/4in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 135cm - 53in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 139cm - 543/4in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 140cm - 55in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 145cm - 57in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 150cm - 59in | DNP
#N/A |  |  |  |  |  |  |  |  |  |  |  |  | 155cm - 61in | DNP
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A