Spreadsheet: 171175d1343654551-urgent-vlookup-array-or-index-help-logic2
Sheet: Pcode

PCA | Area | Relationship Manager | User ID | NArea | Area Number
AB | Aberdeen | Sybille Muir | 00530000005VfD4 | Scotland | 1
AL | St. Albans | [NAME] | 00530000003UUfn | Central | 4
B | Birmingham | [NAME] | 00530000003UUfn | Central | 4
BA | Bath | [NAME] | 00530000004QBne | West | 3
BB | [NAME] | New Starter | N/A | North | 2
BD | Bradford | New Starter | N/A | North | 2
BH | Bournemouth | [NAME] | 00530000004QBne | West | 3
BL | [NAME] | New Starter | N/A | North | 2
BN | Brighton | [NAME] | 00530000003UUfn | Central | 4
BR | Bromley | [NAME] | 00530000003UUfn | Central | 4
BS | Bristol | [NAME] | 00530000004QBne | West | 3
BT | Belfast | Sybille Muir | 00530000005VfD4 | Scotland | 1
CA | Carlisle | New Starter | N/A | North | 2
CB | Cambridge | [NAME] | 00530000003UUfi | East | 5
CF | Cardiff | [NAME] | 00530000004QBne | West | 3
CH | Chester | New Starter | N/A | North | 2
CM | [NAME] | [NAME] | 00530000003UUfn | Central | 4
CO | Colchester | [NAME] | 00530000003UUfi | East | 5
CR | Croydon | [NAME] | 00530000003UUfn | Central | 4
CT | Canterbury | [NAME] | 00530000003UUfn | Central | 4
[NAME] | Coventry | [NAME] | 00530000003UUfn | Central | 4
CW | Crewe | New Starter | N/A | North | 2
DA | [NAME] | [NAME] | 00530000003UUfn | Central | 4
DD | Dundee | Sybille Muir | 00530000005VfD4 | Scotland | 1
DE | Derby | New Starter | N/A | North | 2
DG | Dumfries | Sybille Muir | 00530000005VfD4 | Scotland | 1
DH | [NAME] | New Starter | N/A | North | 2
DL | Darlington | New Starter | N/A | North | 2
DN | Doncaster | New Starter | N/A | North | 2
DT | Dorchester | [NAME] | 00530000004QBne | West | 3
DY | [NAME] | New Starter | N/A | North | 2
E | London (East) | [NAME] | 00530000003UUfn | Central | 4
EC | London (East) | [NAME] | 00530000003UUfn | Central | 4
EH | Edinburgh | Sybille Muir | 00530000005VfD4 | Scotland | 1
EN | Enfield | [NAME] | 00530000003UUfn | Central | 4
EX | Exeter | [NAME] | 00530000004QBne | West | 3
FK | Falkirk | Sybille Muir | 00530000005VfD4 | Scotland | 1
FY | Blackpool | New Starter | N/A | North | 2
G | [NAME] | Sybille Muir | 00530000005VfD4 | Scotland | 1
GL | Gloucester | [NAME] | 00530000004QBne | West | 3
GU | [NAME] | [NAME] | 00530000003UUfn | Central | 4
GY | Guernsey | [NAME] | 00530000004QBne | West | 3
HA | [NAME] | [NAME] | 00530000003UUfn | Central | 4
HD | Huddersfield | New Starter | N/A | North | 2
HG | Harrogate | New Starter | N/A | North | 2
HP | [NAME] | [NAME] | 00530000003UUfn | Central | 4
HR | [NAME] | [NAME] | 00530000004QBne | West | 3
HS | Hebrides | Sybille Muir | 00530000005VfD4 | Scotland | 1
[NAME] | Hull | New Starter | N/A | North | 2
HX | Halifax | New Starter | N/A | North | 2
IG | Ilford | [NAME] | 00530000003UUfn | Central | 4
IM | Isle of Man | New Starter | N/A | North | 2
IP | Ipswich | [NAME] | 00530000003UUfi | East | 5
IV | Inverness | Sybille Muir | 00530000005VfD4 | Scotland | 1
JE | Jersey | [NAME] | 00530000004QBne | West | 3
KA | Kilmarnock | Sybille Muir | 00530000005VfD4 | Scotland | 1
KT | [NAME] | [NAME] | 00530000003UUfn | Central | 4
KW | Kirkwall | Sybille Muir | 00530000005VfD4 | Scotland | 1
KY | Kirkcaldy | Sybille Muir | 00530000005VfD4 | Scotland | 1
L | Liverpool | New Starter | N/A | North | 2
LA | Lancaster | New Starter | N/A | North | 2
LD | Llandindod We | [NAME] | 00530000004QBne | West | 3
LE | Leicester | New Starter | N/A | North | 2
LL | Llandundo | [NAME] | 00530000004QBne | West | 3
LN | Lincoln | New Starter | N/A | North | 2
LS | Leeds | New Starter | N/A | North | 2
LU | Luton | [NAME] | 00530000003UUfn | Central | 4
M | [NAME] | New Starter | N/A | North | 2
ME | Medway | [NAME] | 00530000003UUfn | Central | 4
MK | [NAME] | [NAME] | 00530000003UUfn | Central | 4
ML | Motherwell | Sybille Muir | 00530000005VfD4 | Scotland | 1
N | London (North) | [NAME] | 00530000003UUfn | Central | 4
NE | Newcastle | New Starter | N/A | North | 2
NG | [NAME] | New Starter | N/A | North | 2
NN | Northampton | [NAME] | 00530000003UUfn | Central | 4
NP | Newport | [NAME] | 00530000004QBne | West | 3
NR | [NAME] | [NAME] | 00530000003UUfi | East | 5
NW | London (Northwest) | [NAME] | 00530000003UUfn | Central | 4
OL | Oldham | New Starter | N/A | North | 2
OX | Oxford | [NAME] | 00530000003UUfn | Central | 4
PA | Paisley | Sybille Muir | 00530000005VfD4 | Scotland | 1
PE | Peterborough | [NAME] | 00530000003UUfi | East | 5
PH | Perth | Sybille Muir | 00530000005VfD4 | Scotland | 1
PL | Plymouth | [NAME] | 00530000004QBne | West | 3
PO | Portsmouth | [NAME] | 00530000003UUfn | Central | 4
PR | Preston | New Starter | N/A | North | 2
RG | Reading | [NAME] | 00530000003UUfn | Central | 4
RH | Redhill | [NAME] | 00530000003UUfn | Central | 4
RM | Romford | [NAME] | 00530000003UUfn | Central | 4
S | Sheffield | New Starter | N/A | North | 2
SA | Swansea | [NAME] | 00530000004QBne | West | 3
SE | London (Southeast) | [NAME] | 00530000003UUfn | Central | 4
SG | Stevenage | [NAME] | 00530000003UUfn | Central | 4
SK | Stockport | New Starter | N/A | North | 2
SL | Slough | [NAME] | 00530000003UUfn | Central | 4
SM | Sutton | [NAME] | 00530000003UUfn | Central | 4
SN | Swindon | [NAME] | 00530000004QBne | West | 3
SO | Southampton | [NAME] | 00530000003UUfn | Central | 4
SP | Salisbury | [NAME] | 00530000004QBne | West | 3
SR | Sunderland | New Starter | N/A | North | 2
SS | Southend on Sea | [NAME] | 00530000003UUfn | Central | 4
ST | Stoke on Trent | New Starter | N/A | North | 2
SW | London (Southwest) | [NAME] | 00530000003UUfn | Central | 4
SY | Shrewsbury | [NAME] | 00530000004QBne | West | 3
TA | Taunton | [NAME] | 00530000004QBne | West | 3
TD | Galashiels | Sybille Muir | 00530000005VfD4 | Scotland | 1
TF | Telford | New Starter | N/A | North | 2
TN | Tonbridge | [NAME] | 00530000003UUfn | Central | 4
TQ | Torquay | [NAME] | 00530000004QBne | West | 3
TR | Truro | [NAME] | 00530000004QBne | West | 3
TS | Cleveland | New Starter | N/A | North | 2
TW | [NAME] | [NAME] | 00530000003UUfn | Central | 4
UB | Southall | [NAME] | 00530000003UUfn | Central | 4
W | London (West) | [NAME] | 00530000003UUfn | Central | 4
WA | Warrington | New Starter | N/A | North | 2
WC | London (WC) | [NAME] | 00530000003UUfn | Central | 4
WD | Watford | [NAME] | 00530000003UUfn | Central | 4
WF | Wakefield | New Starter | N/A | North | 2
WN | [NAME] | New Starter | N/A | North | 2
WR | Worcester | [NAME] | 00530000004QBne | West | 3
WS | Walsall | New Starter | N/A | North | 2
WV | Wolverhampton | New Starter | N/A | North | 2
YO | York | New Starter | N/A | North | 2
ZE | Lerwick (Shetland) | Sybille Muir | 00530000005VfD4 | Scotland | 1