Spreadsheet: 47775d1246956334-using-a-dropdown-list-where-selction-is-dependant-on-another-list-region
Sheet: Region

Region |  |  | Area:
 |  | Drop down list |  | Region |  | Ignore |  | Southwark |  | Ignore
 |  |  |  | Blyth |  |  |  | A |  | Error
 |  |  |  | Brent |  |  |  | B |  | Error
 |  |  |  | Croydon |  |  |  | C |  | Error
 |  |  |  | [NAME] |  |  |  | D |  | Error
 |  |  |  | Edinburgh |  |  |  | E |  | Error
 |  |  |  | Enfield |  |  |  | F |  | Error
 |  |  |  | Greenwich |  |  |  | G |  | Error
 |  |  |  | Harlow |  |  |  | H |  | Error
 |  |  |  | [NAME] |  |  |  | I |  | Error
 |  |  |  | Medway |  |  |  |  |  | Error
 |  |  |  | [NAME] |  |  |  |  |  | Error
 |  |  |  | Southwark |  |  |  |  |  | Error
 |  |  |  | Wandsworth |  |  |  |  |  | Error
 |  |  |  | Burnley |  |  |  |  |  | Error
 |  |  |  |  |  |  |  |  |  | Error
 |  |  |  |  |  |  |  | Croydon
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | I
 |  |  |  |  |  |  |  | J
 |  |  |  |  |  |  |  | Brent
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | Medway
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | Enfield
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | I
 |  |  |  |  |  |  |  | J
 |  |  |  |  |  |  |  | K
 |  |  |  |  |  |  |  | Edinburgh
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | I
 |  |  |  |  |  |  |  | J
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | I
 |  |  |  |  |  |  |  | Greenwich
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | Wandsworth
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | Blyth
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | I
 |  |  |  |  |  |  |  | J
 |  |  |  |  |  |  |  | K
 |  |  |  |  |  |  |  | Harlow
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | I
 |  |  |  |  |  |  |  | J
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  | I
 |  |  |  |  |  |  |  | Burnley
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  | H