Spreadsheet: 57068d1257252067-using-v-lookup-to-search-data-test-1-
Sheet: Sheet1

Location |  | Site_Num | Site_Area
High Street, [NAME], Windsor, Berkshire   -   (ETON,[NAME])   -   (UKRB) SL4 6AU | SL4 6AU | 2398 | 42-E
The Castle Point Centre, Castle Lane West, Bournemouth, Dorset   -   (BOURNEMOUTH, CASTLE POINT CENTRE, grd)   -   (UKRB) BH8 9UW | BH8 9UW
Marine Parade, St Mawes, Truro  , [NAME]   -   (ST MAWES,grd)   -   (UKRB) TR2 5DW | TR2 5DW | 1453 | 39-R
Embassy House, 86 Queens Road, Clifton , Bristol, Somerset   -   (BRISTOL CLIFTON,sub b'ment,b,grd,1st,2nd)   -   (UKRB) BS8 1RB | BS8 1RB | 2326 | 40-B
RMC Training Centre, Lympstone, Exmouth, [NAME]   -   (LYMPSTONE RMC TRAINING CENTRE,grd)   -   (UKRB) EX8 5AR | EX8 5AR | 3069 | 41-Z
6 High Street, Marlborough, [NAME]   -   (MARLBOROUGH,b'ment,grd)   -   (UKRB) SN8 1AA | SN8 1AA
6 High Street, Marlborough, [NAME]   -   (MARLBOROUGH,b'ment,grd)   -   (UKRB) SN8 1AA | SN8 1AA
7 Mount Folly Square, [NAME], [NAME]   -   (BODMIN,b'ment,grd,1st,2nd)   -   (UKRB) PL31 2DE | PL31 2DE | 2342 | 39-R
202/204 Lower Blandford Road, Broadstone, Poole, Dorset   -   (BROADSTONE,grd)   -   (UKRB) BH18 8DP | BH18 8DP
214-216  Stapleton Road, Bristol , Somerset   -   (BRISTOL STAPLETON RD,grd,1st,2nd)   -   (UKRB) BS5 0NX | [NAME] | 2324 | 40-B
53 [NAME], Mount Charles, [NAME]  , [NAME]   -   (MOUNT CHARLES,grd,1st,2nd)   -   (UKRB) PL25 4QF | [NAME]
The Triangle, Tilehurst, Reading, Berkshire   -   (TILEHURST,b'ment,[NAME])   -   (UKRB) RG3 4RW | RG3 4RW
The Triangle, Tilehurst, Reading, Berkshire   -   (TILEHURST,b'ment,[NAME])   -   (UKRB) RG3 4RW | RG3 4RW
1 High Street, Westbury-on-Trym, Bristol  , Somerset   -   (WESTBURY ON TRYM,[NAME])   -   (UKRB) BS9 3DR | BS9 3DR
6 Market Place, Newbury, Berkshire   -   (NEWBURY MARKET PLACE,grd,1st,2nd)   -   (UKRB) RG14 5AY | RG14 5AY
14/15 King Street, Truro, [NAME]   -   (TRURO KING ST,b'ment,grd,1st,2nd)   -   (UKRB) TR1 2RA | TR1 2RA
15 Haven Road, [NAME], Poole   , [NAME]   -   ([NAME],grd,1st,2nd)   -   (UKRB) BH13 7LF | BH13 7LF
17-18a King [NAME], Yeovil , Somerset   -   ([NAME],b,grd,1st,2nd,3rd)   -   (UKRB) BA20 1QJ | BA20 1QJ
3 & 5a  The Parade, [NAME], Somerset   -   (MINEHEAD,grd & pt 1st)   -   (UKRB) TA24 5NL | TA24 5NL
14a Queensmere, Slough, Berkshire   -   (SLOUGH QUEENSMERE,b'ment,grd,1st,2nd)   -   (UKRB) SL1 1DT | SL1 1DT
184-192 Crockhamwell Road, [NAME], Reading, Berkshire   -   (WOODLEY BERKS,grd,1st,2nd)   -   (UKRB) RG5 3JL | RG5 3JL
129-131-131A  Poole Road, [NAME], [NAME], Dorset   -   (WESTBOURNE,b'ment,[NAME])   -   (UKRB) BH4 9BJ | BH4 9BJ
113 Winchester Road, Chandlers Ford, Eastleigh, [NAME]   -   (CHANDLERS FORD,[NAME])   -   (UKRB) SO5 2ZA | SO5 2ZA
290 Wimborne Road, Winton, Bournemouth , Dorset   -   (WINTON,b'ment,grd)   -   (UKRB) BH3 7AT | BH3 7AT
788 Fishponds Road, Fishponds, Bristol, Somerset   -   (FISHPONDS,grd,1st,2nd)   -   (UKRB) BS16 3TE | BS16 3TE
29/30 High Street, Windsor, Berkshire   -   (WINDSOR HIGH ST,b'ment,grd flr)   -   (UKRB) SL4 1PG | SL4 1PG
17 Queen Street, Lostwithiel, [NAME]   -   (LOSTWITHIEL,grd)   -   (UKRB) PL22 0AD | PL22 0AD
17 Queen Street, Lostwithiel, [NAME]   -   (LOSTWITHIEL,grd)   -   (UKRB) PL22 0AD | PL22 0AD
84 Mostyn Street, Llandudno, Gwynedd   -   (LLANDUDNO MOSTYN ST,b'ment,grd,1st,2nd)   -   (UKRB) LL30 2SB | LL30 2SB
22 Harpur Street, Bedford, Bedfordshire   -   (Bedford WOOLWICH SBU)   -   (UKRB) MK40 1LB | MK40 1LB
Aldermans Hill, Palmers Green, London, Greater London   -   (PALMERS GREEN ALDRMNS 2/4,b,g,1st,2nd)   -   (UKRB) N13 4PT | N13 4PT
Aldermans Hill, Palmers Green, London, Greater London   -   (PALMERS GREEN ALDRMNS 2/4,b,g,1st,2nd)   -   (UKRB) N13 4PT | N13 4PT
Aldermans Hill, Palmers Green, London, Greater London   -   (PALMERS GREEN ALDRMNS 2/4,b,g,1st,2nd)   -   (UKRB) N13 4PT | N13 4PT
Aldermans Hill, Palmers Green, London, Greater London   -   (PALMERS GREEN ALDRMNS 2/4,b,g,1st,2nd)   -   (UKRB) N13 4PT | N13 4PT
Aldermans Hill, Palmers Green, London, Greater London   -   (PALMERS GREEN ALDRMNS 2/4,b,g,1st,2nd)   -   (UKRB) N13 4PT | N13 4PT
Aldermans Hill, Palmers Green, London, Greater London   -   (PALMERS GREEN ALDRMNS 2/4,b,g,1st,2nd)   -   (UKRB) N13 4PT | N13 4PT
2/10 Pinstone Street, Sheffield, South Yorkshire   -   (SHEFFIELD, [NAME], b,g,1-4 flrs)   -   (UKRB) S1 2HN | S1 2HN
139/142 North St, Brighton, West Sussex   -   (BRIGHTON NORTH ST,b,grd,[NAME])   -   (UKRB) BN1 1RU | BN1 1RU
227-231 Heathway, Dagenham, Essex   -   (DAGENHAM HEATHWAY,grd)   -   (UKRB) RM9 5AN | RM9 5AN
216-216A-218-220 Stamford Hill, London, Greater London   -   (STAMFORD HILL,[NAME])   -   (UKRB) [NAME] 6RA | N16 6RA
5 High Road, Willesden Green, London   -   (WILLESDEN GREEN,b'ment,grd,1st,2nd,3rd)   -   (UKRB) NW10 2TE | NW10 2TE
521/523 Prescot Road, Old Swan, Liverpool, Merseyside   -   (LIVERPOOL OLD SWAN,b'ment,grd,1st,2nd)   -   (UKRB) [NAME] 5US | [NAME] 5US
78 Regent Street, Kingswood, Bristol, Somerset   -   (BRISTOL KINGSWOOD,[NAME])   -   (UKRB) BS15 8JA | BS15 8JA
9 High Street, Grays, Essex   -   (GRAYS,b'ment,grd,1st,2nd)   -   (UKRB) RM17 6NB | RM17 6NB
9 High Street, Grays, Essex   -   (GRAYS,b'ment,grd,1st,2nd)   -   (UKRB) RM17 6NB | RM17 6NB
9 High Street, Grays, Essex   -   (GRAYS,b'ment,grd,1st,2nd)   -   (UKRB) RM17 6NB | RM17 6NB
9 High Street, Grays, Essex   -   (GRAYS,b'ment,grd,1st,2nd)   -   (UKRB) RM17 6NB | RM17 6NB
9 High Street, Grays, Essex   -   (GRAYS,b'ment,grd,1st,2nd)   -   (UKRB) RM17 6NB | RM17 6NB
9 High Street, Grays, Essex   -   (GRAYS,b'ment,grd,1st,2nd)   -   (UKRB) RM17 6NB | RM17 6NB
9 High Street, Grays, Essex   -   (GRAYS,b'ment,grd,1st,2nd)   -   (UKRB) RM17 6NB | RM17 6NB
Islington Green, Camden Passage, Camden Town, London, Greater London   -   (ISLINGTON ISLINGTON GREEN 38,b,[NAME])   -   (UKRB) N1 8DU | N1 8DU
Islington Green, Camden Passage, Camden Town, London, Greater London   -   (ISLINGTON ISLINGTON GREEN 38,b,[NAME])   -   (UKRB) N1 8DU | N1 8DU
66 High Street, Ashford, [NAME]   -   (ASHFORD KENT HIGH ST,grd,1st,2nd)   -   (UKRB) TN24 8TL | TN24 8TL
Unit 341, Lakeside, Thurrock, Essex   -   (Thurrock WOOLWICH SBU)   -   (UKRB) RM16 1ZH | RM16 1ZH
15-17 Great Portland Street,  6/7 Great Castle Street, Oxford Circus, London, Central London   -   (OXFORD CIRCUS GT PORTLAND ST,b,[NAME])   -   (UKRB) W1A 4TR | W1A 4TR
15-17 Great Portland Street,  6/7 Great Castle Street, Oxford Circus, London, Central London   -   (OXFORD CIRCUS GT PORTLAND ST,b,[NAME])   -   (UKRB) W1A 4TR | W1A 4TR
1 Churton Street, [NAME], London   -   (VAUXHALL BRIDGE RD,b'ment,[NAME])   -   (UKRB) SW1V 2JX | SW1V 2JX
1 Churton Street, [NAME], London   -   (VAUXHALL BRIDGE RD,b'ment,[NAME])   -   (UKRB) SW1V 2JX | SW1V 2JX
37-39 Rose Hill 1/3 Soresby Street, Chesterfield, Derbyshire   -   (CHESTERFIELD,b'ment,grd)   -   (UKRB) S40 1TT | [NAME] 1TT
26-28 Regent Street, Swindon, [NAME]   -   (SWINDON REGENT ST,b'ment,grd,1st,2nd)   -   (UKRB) SN1 1QB | SN1 1QB
50-52  Abbeygate Street, Bury St Edmunds, Suffolk   -   (BURY ST EDMUNDS ABBEYGATE,b,g,1st-3rd)   -   (UKRB) IP33 1LB | IP33 1LB
[NAME], Kingston-upon-Thames, [NAME]   -   (KINGSTON-U-T KINGSTON HILL,b'ment,[NAME])   -   (UKRB) KT2 7NJ | KT2 7NJ
Yorkshire Street, Rochdale, Lancashire   -   (ROCHDALE YORKSHIRE ST,b,grd,1st,2nd,3rd)   -   (UKRB) OL16 1BJ | OL16 1BJ
143 High Street, Henley-in-Arden, Solihull  , West Midlands   -   (HENLEY IN ARDEN,grd)   -   (UKRB) B95 5BA | B95 5BA
50-52  Abbeygate Street, Bury St Edmunds, Suffolk   -   (BURY ST EDMUNDS ABBEYGATE,b,g,1st-3rd)   -   (UKRB) IP33 1LB | IP33 1LB
2 Windsor Road, Penarth, South Glamorgan   -   ([NAME],grd,1st,2nd)   -   (UKRB) CF64 1JH | CF64 1JH
74/76 New Road, Gravesend, [NAME]   -   (GRAVESEND,[NAME])   -   (UKRB) DA11 0AF | DA11 0AF
16 High Street, High Wycombe, Buckinghamshire   -   (HIGH WYCOMBE HIGH ST,grd,1st,2nd)   -   (UKRB) HP11 2BG | HP11 2BG
64/66 High Street, Ewell, [NAME], [NAME]   -   (EWELL,[NAME])   -   (UKRB) KT17 1RN | KT17 1RN
27-29  Swakeleys Road, [NAME], Uxbridge, Middlesex   -   (ICKENHAM,[NAME], rear warehouse)   -   (UKRB) UB10 8DE | UB10 8DE
27-29  Swakeleys Road, [NAME], Uxbridge, Middlesex   -   (ICKENHAM,[NAME], rear warehouse)   -   (UKRB) UB10 8DE | UB10 8DE
39-43 High Street, [NAME], Cambridgeshire   -   (ST NEOTS,[NAME])   -   (UKRB) PE19 1BN | PE19 1BN
59 Newland Street, Witham, Essex   -   (WITHAM NEWLAND ST,b'ment,[NAME])   -   (UKRB) CM8 2BD | CM8 2BD
The Castle Point Centre, Castle Lane West, Bournemouth, Dorset   -   (BOURNEMOUTH, CASTLE POINT CENTRE, grd)   -   (UKRB) BH8 9UW | BH8 9UW
Broad Street, Hereford, Herefordshire   -   (HEREFORD BROAD ST,b'ment,grd,1st,2nd)   -   (UKRB) HR4 9AP | HR4 9AP
29/30 High Street, Windsor, Berkshire   -   (WINDSOR HIGH ST,b'ment,grd flr)   -   (UKRB) SL4 1PG | SL4 1PG
53-55  High Street, Worcester , West Midlands   -   (WORCESTER HIGH ST,b'ment,grd,1st,2nd,3rd)   -   (UKRB) WR1 2QB | WR1 2QB
21 - 22  High Street, Ferndale, [NAME]  , [NAME](FERNDALE,grd,1st)   -   (UKRB) CF43 4RN | CF43 4RN