Spreadsheet: 702508d1604397160-how-to-look-up-multiple-values-branch-mail-merge-info-sample-2-
Sheet: Branch info

Branch No | Branch Name | Stock 1 | Pipcode 1 | Stock 2 | Pipcode 2 | Stock 3 | Pipcode 3 | Stock 4 | Pipcode 4 | Stock 5 | Pipcode 5 | Stock 6 | Pipcode 6 | Stock 7 | Pipcode 7 | Stock 8 | Pipcode 8 | Stock 9 | Pipcode 9 | Stock 10 | Pipcode 10
1001 | BRYNTEG
1002 | CHIRK
1003 | COEDPOETH
1005 | FLINT
1006 | PEN Y MAES
1008 | ST ASAPH
1009 | [NAME]
1010 | TYWYN
1011 | OVERTON-ON-DEE
1013 | BRON DERW
1015 | WELSHPOOL
1016 | BROMBOROUGH
1017 | GARDEN VILLAGE
1018 | CREWE
1019 | RUABON
1020 | PORTHMADOG PO
1021 | CONNAH'S QUAY
1022 | MIDDLEWICH
1023 | [NAME]
1025 | DENBIGH
1026 | RHAYADER
1027 | QUEENSFERRY
1028 | HARTFORD
1029 | [NAME]
1030 | [NAME]
1031 | BEAUMARIS
1033 | UPTON
1034 | [NAME],BANGOR
1035 | DOLGELLAU
1037 | KINGS DRIVE
1038 | HASLINGTON
1039 | CHAPEL STREET
1040 | ST GEORGES CRES
1041 | UPHOLLAND
1042 | HADLEY
1043 | WHITCHURCH
1044 | PRESTATYN
1045 | KINGS MILLS
1046 | AMLWCH
1047 | COLESHILL STREET
1048 | HALKYN ROAD
1049 | WEM
1051 | BUCKLEY
1052 | RHOS-ON-SEA
1054 | CEMAES BAY
1056 | [NAME]
1057 | CEFN MAWR
1058 | RHOSDDU
1059 | CONWY CASTLE ST
1061 | LLANBERIS
1062 | PORTHMADOG HIGH ST
1063 | CORWEN
1064 | SUTTON FARM
1065 | BOLSOVER
1066 | HOLYHEAD
1068 | BAYSTON HILL
1069 | LLANGOLLEN
1070 | BARMOUTH
1071 | HARLESCOTT
1072 | PARKFIELD
1073 | NEW FERRY
1074 | BROSELEY
1075 | BORRAS PARK
1077 | [NAME]
1079 | BENLLECH
1081 | SPEKE HEALTH CENTRE
1082 | MORRISONS SPEKE
1085 | WESTFALING PHARMACY
1088 | CONWY HIGH ST
1089 | [NAME]
1094 | STRATHMORE
1140 | LOWER CARDIFF RD
1141 | Y MAES
1142 | HIGH ST PWLLHELI
1144 | [NAME]
1145 | WIDNES
1146 | GATLEY
1147 | HOPE FARM
1148 | RHYL
1149 | ELLESMERE PORT
1150 | POYNTON
1151 | SALFORD
1152 | LANGLEY
1153 | NORTHGATE AVE
1155 | OLD TRAFFORD
1159 | MANSFIELD WOODHOUSE
1160 | SHERWOOD STREET
1161 | NEWGATE LANE
1162 | CHURCH STREET
1163 | CHESTERFIELD ROAD
1164 | MEDEN VALE
1168 | COLLEGE
1169 | PRESTBURY
1170 | LECKHAMPTON
1171 | COWLEY
1173 | WOOD FARM
1175 | WITNEY
1176 | MANOR
1177 | CHOLSEY
1178 | [NAME]
1179 | OLDHAM
1180 | HOLT ROAD
1181 | ASHURST
1182 | 38 TOWN END
1183 | AGARD ST
1184 | FITZWILLIAM STREET
1185 | MOLDGREEN
1186 | MELTHAM
1187 | LEPTON
1188 | KIRKBURTON
1189 | EARLSHEATON
1190 | ALMONDBURY
1191 | NEWSOME
1192 | WATERLOO
1193 | [NAME]
1194 | [NAME]
1195 | SOWERBY BRIDGE
1196 | MILLOM
1197 | SANDAL
1198 | KETTLETHORPE
1199 | MAPPLEWELL
1201 | AUGHTON
1203 | CASTLETOWN
1205 | TOWNSEND AVENUE
1206 | TARLETON
1207 | MAGHULL
1210 | LINCOLN ROAD
1211 | [NAME]
1214 | 157 LODGE LANE
1216 | DERBY LANE
1217 | [NAME]
1218 | GREAT HOMER STREET
1219 | HUYTON
1220 | LONGMOOR LANE
1221 | MELLING
1223 | LEESIDE AVENUE
1224 | PICTON ROAD
1225 | ROCKFERRY
1227 | TOWER HILL
1228 | ORMSKIRK
1229 | 6 LODGE LANE
1231 | BROAD LANE
1232 | TANNERS LANE
1233 | THELWALL LANE
1234 | WALLASEY
1235 | MARSH GREEN
1236 | [NAME]
1237 | WESTVALE
1238 | GREENWAY ROAD
1240 | CLIFTON COURT
1241 | NEASHAM ROAD
1242 | WEST AUCKLAND ROAD
1243 | CARMEL PHARMACY
1244 | HIGH ROW
1245 | NORTH ROAD
1246 | BLACKETTS
1247 | PALLION
1248 | MILLFIELD
1249 | ST LUKES TERRACE
1250 | OLD FORGE
1251 | 189 CHESTER ROAD
1252 | SALTWELL ROAD
1254 | ASHTONS
1256 | EAVESWAY
1257 | [NAME]
1258 | [NAME] ROAD
1259 | BRIERFIELD
1261 | TINGLEY
1262 | [NAME]
1263 | FERRIES
1264 | KEIGHLEY
1265 | GUNNS
1266 | HARLECH
1267 | FORMANS LANGLEY
1268 | DYKES HALL
1269 | BARNSLEY ROAD
1270 | BELLHOUSE ROAD
1271 | [NAME] ROAD
1272 | BEVAN WAY
1274 | GREENHOW STREET
1275 | ECCLESALL ROAD
1276 | PRESTON
1278 | [NAME]
1279 | MILNTHORPE
1280 | ARNSIDE
1281 | WRENTHORPE
1282 | MAYFLOWER WAY
1283 | [NAME]
1284 | MORETON
1286 | STIRCHLEY
1287 | QUEENSBURY
1290 | FIVE LANE ENDS
1292 | WOKING
1293 | PARK CHEMIST
1294 | COWPLAIN
1295 | CLANFIELD
1296 | SPEDDINGS GATESHEAD
1297 | SUSSEX SQUARE
1298 | KINGSWOOD AVENUE
1299 | SOUTH ELMSALL
1300 | MCALLISTERS BOLTON
1301 | CAPTAIN LEES
1302 | HEATONS
1303 | [NAME]
1304 | KNOTTINGLEY
1306 | DALGETY BAY
1307 | YORK ROAD ROTHERHAM
1308 | FIVEWAYS
1309 | BUGDEN & PARR
1310 | GOSPORT
1311 | FERRYBRIDGE
1312 | MEADOW
1314 | BALMORE ROAD
1315 | BO'NESS
1316 | COATBRIDGE
1317 | CUMBERNAULD
1318 | GILBERTFIELD STREET
1319 | GRANGEMOUTH
1320 | HILLKIRK CORNER
1321 | CORSTORPHINE
1322 | AUSTEN'S
1323 | EASTBANK
1324 | CREEKMOOR
1326 | PARKSTONE ROAD
1327 | LONG FLEET ROAD
1329 | OAKDALE
1330 | LLANFAIR PG
1331 | MENAI BRIDGE
1333 | WESTBOURNE
1334 | SOUTHSEA
1335 | TRAWSFYNYDD
1336 | MILTON ROAD
1337 | SELBY
1338 | DUNDEE
1339 | BELMONT HEREFORD
1340 | TOLPUDDLE GDNS
1341 | FLEET
1343 | SHIPLEY
1344 | [NAME]
1345 | NEWTON LE WILLOWS
1347 | AUGHTON ROAD
1348 | LITHERLAND
1349 | FRATTON ROAD
1350 | PORTCHESTER
1352 | PAULSGROVE
1353 | HIGHLAND ROAD
1354 | EASTNEY ROAD
1355 | KINGSTON CRESCENT
1356 | [NAME] ROAD
1357 | BRIDGEMARY
1358 | OSBORNE ROAD
1360 | [NAME]
1361 | ENDURANCE HOUSE
1362 | TENNANT STREET
1364 | ASHINGTON
1366 | WEST END
1367 | GLOUCESTER
1368 | CHANINS
1369 | SALE
1370 | ALTRINCHAM
1371 | MILNROW HEALTH CENTRE
1373 | CHESHAM
1374 | BIRKDALE
1375 | COPPICE AVE
1376 | BROMYARD
1378 | DAYBROOK
1379 | SHEPSHED
1380 | SHIREBROOK
1381 | LAWSON STREET
1382 | [NAME]
1383 | DALTON SQUARE
1385 | SALFORD LPS
1386 | HENLEY AVE
1387 | WELLINGBOROUGH
1388 | MIDDLETON
1389 | NITHSDALE ROAD
1390 | CUPAR
1391 | ENSBURY PARK
1393 | BOLLINGTON
1394 | ORPINGTON
1395 | BROMLEY
1396 | BEMERTON HEATH
1397 | HARCOURT
1398 | MILLSTREAM
1400 | [NAME]
1401 | BOSCOMBE
1402 | AUCHTERMUCHTY
1403 | FERRING
1404 | FERNDOWN
1405 | PRESCOT
1406 | TOWNGATE
1407 | WEST PADDOCK
1408 | [NAME]
1409 | CALDERWOOD SQUARE
1410 | ST LEONARDS SQUARE
1411 | HUNTER STREET
1412 | CLAYTON
1413 | PAISLEY ROAD WEST
1414 | RENFREW
1415 | FOREHILL
1416 | NEWTON MEARNS
1417 | HELENSBURGH
1418 | REDDITCH
1419 | GORING BY SEA
1420 | NEWPORT ON TAY
1421 | LOW EDGES ROAD
1422 | RUGBY
1423 | KINROSS
1424 | FIVE OAKS
1425 | BESWICK
1426 | MIDDLESBROUGH
1427 | CULLODEN
1428 | LANCING
1429 | BONNYRIGG
1430 | LOANHEAD
1431 | EDINBURGH ROAD
1432 | CLEETHORPES
1435 | ELLON
1436 | CULTS
1437 | MINTLAW
1439 | PENICUIK
1440 | BEDALE
1442 | GEORGE STREET
1443 | BYRON SQUARE
1444 | CITY HOSPITAL
1445 | SKEGNESS
1446 | HAZLEMERE
1447 | TOTTERIDGE [NAME]
1448 | ALEXANDRA ROAD
1449 | UPTON CROSS
1450 | MEADOW WAY
1451 | ELMHURST
1452 | STAFFORD
1453 | DINGLE BELLS
1454 | FIELD ROAD
1456 | MERLEY
1457 | GORSTY LANE
1459 | NEWHEY ROAD
1461 | STRATFORD
1462 | GRANT STREET
1464 | YEOVIL
1465 | ROSYTH
1466 | RUSHDEN
1468 | CORPORATION STREET
1469 | MAYTHORNE CLOSE
1471 | BROCKHAM GREEN
1472 | ELM GROVE
1473 | FOUR ACRE
1474 | ASTLEY
1475 | KNUTSFORD
1476 | SALE MOOR
1477 | DINGLE
1478 | ELSWICK ROAD
1479 | NORTHERN MOOR
1480 | ST CHADS
1481 | BRIERCLIFFE ROAD
1482 | MARKET SQUARE
1483 | GUARDIAN STREET
1484 | ADLINGTON
1485 | AIGBURTH
1486 | RAWTENSTALL
1487 | ORFORD
1488 | [NAME]
1491 | LONDON ROAD
1492 | CROOKHORN LANE
1493 | LAVENDER ROAD
1494 | BEDHAMPTON ROAD
1495 | LEIGH PARK
1497 | STOKE ROAD
1499 | LITTLEMOOR
1500 | WEYMOUTH
1501 | BOURTON
1502 | CHURCH GREEN
1503 | TENBURY
1506 | ILLINGWORTH ROAD
1507 | POINTER COURT
1509 | BALLOAN PARK
1510 | HOLLYHEDGE ROAD
1511 | BLOXWICH
1512 | BIRMINGHAM ROAD
1513 | THE PINFOLD
1514 | TAMWORTH
1516 | INGOL
1517 | EAST QUAY
1518 | HAYWARDS HEATH
1519 | WEST PARK
1520 | ROWLEY REGIS
1522 | FARNHAM
1523 | COLNE
1524 | NORRIS GREEN
1525 | POUNDBURY
1526 | DEVIZES
1529 | LESLIE ROAD
1530 | BUTTERSHAW LANE
1533 | COP LANE
1534 | OAKLANDS
1535 | WHETLEY HILL
1536 | BURNGREAVE ROAD
1538 | PILCH LANE
1539 | BILLINGHAM
1540 | HEANOR
1541 | PORTLAND STREET
1542 | WESTGATE
1544 | UNSWORTH
1546 | FAIRLANDS
1547 | DIGMOOR
1548 | [NAME]
1549 | PRIORY ROAD
1550 | KENNELWOOD AVE
1551 | NORTHWOOD
1552 | LOWTON
1553 | HILLSIDE HEALTH CENTRE
1554 | CLEVEDON
1555 | WILSDEN
1556 | TAYPORT
1558 | CLACTON-ON-SEA
1559 | RICHMOND TERRACE
1560 | CLIFTON ROAD
1561 | DUNCHURCH
1563 | HORNCHURCH
1564 | FRINTON-ON -SEA
1565 | BRICKFIELD ROAD
1566 | BROADSTAIRS
1567 | CROSSWAYS
1568 | ST JOHN'S ROAD
1569 | LEIGH ON SEA
1570 | 227 BANBURY ROAD
1571 | 194 BANBURY ROAD
1572 | COVENTRY
1573 | BENTALLS CENTRE
1574 | SHENFIELD
1575 | LUTON
1576 | CHINGFORD
1577 | MARGATE
1578 | DOWNEMEAD
1579 | HORNS LANE
1580 | ARUNDEL ROAD
1581 | GREAT WAKERING
1582 | NAYLAND ROAD
1583 | FAIRVIEW PARADE
1584 | MORDEN
1585 | EXMOUTH MARKET
1586 | KENTISH TOWN
1587 | MARLBOROUGH PARADE
1588 | ETHEL ROAD
1589 | WHITMORE WAY
1590 | SUNDON PARK
1591 | WALTON
1592 | HISTON ROAD
1594 | CLECKHEATON
1595 | DENMARK STREET
1596 | LYNDHURST
1597 | CULLINGWORTH
1598 | RIBBLETON
1600 | YAXLEY
1602 | ALDERSHOT
1604 | IMPERIAL ROAD
1610 | WHITBY
1611 | MANZIL WAY
1612 | GARSINGTON ROAD
1629 | BILLINGHAM HEALTH CENTRE
1630 | ELDENE PHARMACY
1631 | PARK LANE
1632 | RODBOURNE ROAD
1633 | OLD TOWN
1634 | TOOTHILL
1635 | JOHNSTOWN
1636 | ADDINGHAM
1638 | EUXTON
1639 | [NAME]
1641 | COPNOR ROAD
1642 | BALLS ROAD
1644 | THE WATERFRONT
1645 | CAERNARFON
1646 | PIGGOTT STREET
1647 | HIGHFIELD ROAD
1652 | WROSE
1653 | SPRINGBURN DISPENSARY
1700 | BRIDLINGTON