Spreadsheet: 135398d1326019350-data-validation-trouble-book1
Sheet: Sheet1

DOOR |  | GLASS |  | GLASS COLOUR |  | BACKING PATTERN |  | Doors | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | SIMPLICITY | MACKINTOSH | ELEGANCE | SPIRIT | VIVARA | BRILLIANCE | PRAIRIE | DIAMOND | BEVEL_DIAMOND | CLASSIC | MURANO |  | Frame | Exterior_Colour | Interior_Colour
CHATSWORTH |  | VIVARA |  | GREEN |  |  |  | CROMFORD | CROMFORD | CHATSWORTH | BRADBOURNE | BRASSINGTON | HATHERSAGE | MIDDLETON | MILLDALE | PILSLEY | THORPE | WINSTER | NONE / CLEAR | NONE / CLEAR | NONE / CLEAR | NONE / CLEAR | RED | NONE / CLEAR | NONE / CLEAR | RED | RED | RED | RED |  | WHITE | WHITE | WHITE
 |  |  |  |  |  |  |  | CHATSWORTH | SIMPLICITY | SIMPLICITY | MACKINTOSH | SIMPLICITY | SPIRIT | SIMPLICITY | SIMPLICITY | SIMPLICITY | SIMPLICITY | SIMPLICITY |  |  |  |  | BLUE |  |  | BLUE | BLUE | BLUE | BLUE |  | OAK/WHITE | GREEN | GREEN
Exterior Colour |  | Frame Colour |  | Side Frame |  |  |  | BRADBOURNE | MACKINTOSH | MACKINTOSH | SPIRIT | MACKINTOSH | VIVARA | MURANO | MACKINTOSH | MACKINTOSH | MACKINTOSH | MACKINTOSH |  |  |  |  | BLACK |  |  | BLACK | BLACK | BLACK | BLACK |  | ROSEWOOD/WHITE | BLACK | BLACK
WHITE |  | WHITE |  |  |  |  |  | BRASSINGTON | ELEGANCE | ELEGANCE | VIVARA | ELEGANCE | DIAMOND | STD CLEAR | ELEGANCE | SPIRIT | ELEGANCE | ELEGANCE |  |  |  |  | GREEN |  |  | GREEN | GREEN | GREEN | GREEN |  | BLACK/WHITE | BLUE | BLUE
 |  |  |  |  |  |  |  | HATHERSAGE | SPIRIT | SPIRIT | DIAMOND | SPIRIT | BEVEL_DIAMOND | SOLID | SPIRIT | VIVARA | SPIRIT | SPIRIT |  |  |  |  | NONE / CLEAR |  |  | NONE / CLEAR | NONE / CLEAR | NONE / CLEAR |  |  | OAK/OAK | RED | RED
Interior Colour |  |  |  |  |  |  |  | MIDDLETON | VIVARA | VIVARA | BEVEL_DIAMOND | VIVARA | CLASSIC |  | VIVARA | DIAMOND | VIVARA | VIVARA |  |  |  |  |  |  |  |  |  |  |  |  | ROSEWOOD/ROSEWOOD | OAK | OAK
WHITE |  |  |  |  |  |  |  | MILLDALE | BRILLIANCE | BRILLIANCE | CLASSIC | BRILLIANCE | STD CLEAR |  | BRILLIANCE | BEVEL_DIAMOND | BRILLIANCE | BRILLIANCE | SIMPLICITY | MACKINTOSH | ELEGANCE | SPIRIT | VIVARA | BRILLIANCE | PRAIRIE | DIAMOND | BEVEL_DIAMOND | CLASSIC | MURANO | STD CLEAR | WHITE ASH | ROSEWOOD | ROSEWOOD
 |  |  |  |  |  |  |  | PILSLEY | PRAIRIE | PRAIRIE | MURANO | PRAIRIE |  |  | PRAIRIE | CLASSIC | PRAIRIE | PRAIRIE | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CREAM | SPECIAL* | SPECIAL*
 |  |  |  |  |  |  |  | THORPE | DIAMOND | DIAMOND | STD CLEAR | DIAMOND |  |  | DIAMOND | MURANO | DIAMOND | DIAMOND |  | STIPPOLYTE |  | STIPPOLYTE | STIPPOLYTE |  |  | STIPPOLYTE | STIPPOLYTE | STIPPOLYTE | STIPPOLYTE | STIPPOLYTE
 |  |  |  |  |  |  |  | WINSTER | BEVEL_DIAMOND | BEVEL_DIAMOND |  | BEVEL_DIAMOND |  |  | BEVEL_DIAMOND | STD CLEAR | BEVEL_DIAMOND | BEVEL_DIAMOND |  | MINSTER |  | MINSTER | MINSTER |  |  | MINSTER | MINSTER | MINSTER | MINSTER | MINSTER
 |  |  |  |  |  |  |  |  | CLASSIC | CLASSIC |  | CLASSIC |  |  | CLASSIC |  | CLASSIC | CLASSIC |  | CONTORA |  | CONTORA | CONTORA |  |  | CONTORA | CONTORA | CONTORA | CONTORA | CONTORA
 |  |  |  |  |  |  |  |  | MURANO | MURANO |  | MURANO |  |  | MURANO |  | MURANO | MURANO |  | COTSWOLD |  | COTSWOLD | COTSWOLD |  |  | COTSWOLD | COTSWOLD | COTSWOLD | COTSWOLD | COTSWOLD
 |  |  |  |  |  |  |  |  | STD CLEAR | STD CLEAR |  | STD CLEAR |  |  | STD CLEAR |  | STD CLEAR | STD CLEAR |  | OAK |  | OAK | OAK |  |  | OAK | OAK | OAK | OAK | OAK
 |  |  |  |  |  |  |  |  |  | SOLID |  |  |  |  |  |  | SOLID | SOLID |  | CHARCOAL |  | CHARCOAL | CHARCOAL |  |  | CHARCOAL | CHARCOAL | CHARCOAL | CHARCOAL | CHARCOAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DIGITAL |  | DIGITAL | DIGITAL |  |  | DIGITAL | DIGITAL | DIGITAL | DIGITAL | DIGITAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLORIELLE |  | FLORIELLE | FLORIELLE |  |  | FLORIELLE | FLORIELLE | FLORIELLE | FLORIELLE | FLORIELLE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAFFETA |  | TAFFETA | TAFFETA |  |  | TAFFETA | TAFFETA | TAFFETA | TAFFETA | TAFFETA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PELERINE |  | PELERINE | PELERINE |  |  | PELERINE | PELERINE | PELERINE | PELERINE | PELERINE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHANTILLY |  | CHANTILLY | CHANTILLY |  |  | CHANTILLY | CHANTILLY | CHANTILLY | CHANTILLY | CHANTILLY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EVERGLADE |  | EVERGLADE | EVERGLADE |  |  | EVERGLADE | EVERGLADE | EVERGLADE | EVERGLADE | EVERGLADE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAYFLOWER |  | MAYFLOWER | MAYFLOWER |  |  | MAYFLOWER | MAYFLOWER | MAYFLOWER | MAYFLOWER | MAYFLOWER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WARWICK |  | WARWICK | WARWICK |  |  | WARWICK | WARWICK | WARWICK | WARWICK | WARWICK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ARCTIC |  | ARCTIC | ARCTIC |  |  | ARCTIC | ARCTIC | ARCTIC | ARCTIC | ARCTIC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SYCAMORE |  | SYCAMORE | SYCAMORE |  |  | SYCAMORE | SYCAMORE | SYCAMORE | SYCAMORE | SYCAMORE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUTUMN |  | AUTUMN | AUTUMN |  |  | AUTUMN | AUTUMN | AUTUMN | AUTUMN | AUTUMN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLEMMISH |  | FLEMMISH | FLEMMISH |  |  | FLEMMISH | FLEMMISH | FLEMMISH | FLEMMISH | FLEMMISH