i have a list of postcodes that i need to be able to pre select the zone ie
1-10
example
AB = 1
PE = 3

martin Wrote:
i have a list of postcodes that i need to be able to pre select the zone
ie
1-10
example
AB = 1
PE = 3

Hi Martin

You probably need a lookup table

Need a bit more info to give a better response

Post some example data


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=465872

Thanks Paul
When I recieve data i need the postcde to automaticaly select the zone
Please see below of the specific postcodes and their Zone, ie AB is zone 7


AB 7
AL 2
B 2
BA 4
BB 5
BD 4
BH 4
BL 4
BN 3
BR 2
BS 4
CA 5
CB 1
CF 5
CH 4
CM 2
CO 2
CR 2
CT 3
CV 2
CW 4
DA 2
DD 7
DE 3
DG 6
DH 5
DL 5
DN 4
DT 4
DY 3
E 2
EC 2
EH 6
EN 2
EX 5
FK 7
FY 5
G 6
GL 4
GU 3
HA 2
HD 4
HG 5
HP 2
HR 4
HU 4
HX 4
IG 2
IP 2
IV 7
KA 6
KT 2
KW 7
KY 7
L 4
LA 5
LD 5
LE 2
LL 6
LN 3
LS 4
LU 1
M 4
ME 3
MK 1
ML 6
N 2
NE 5
NG 2
NN 1
NP 4
NR 2
NW 2
OL 4
OX 2
PA 6
PE 2
PH 7
PL 6
PO 3
PR 5
RG 3
RH 3
RM 2
S 3
SA 5
SE 2
SG 1
SK 4
SL 2
SM 2
SN 3
SO 3
SP 3
SS 2
ST 3
SW 2
SY 3
TA 5
TD 6
TF 3
TN 3
TQ 6
TR 6
TS 5
TW 2
UB 2
W 2
WA 4
WC 2
WD 2
WF 4
WN 4
WR 2
WS 2
WV 3
YO 5




"martin" wrote:

i have a list of postcodes that i need to be able to pre select the zone ie
1-10
example
AB = 1
PE = 3

martin Wrote:
Thanks Paul
When I recieve data i need the postcde to automaticaly select the zone
Please see below of the specific postcodes and their Zone, ie AB is
zone 7


AB 7
AL 2
B 2
BA 4
BB 5
BD 4
BH 4
BL 4
BN 3
BR 2
BS 4
CA 5
CB 1
CF 5
CH 4
CM 2
CO 2
CR 2
CT 3
CV 2
CW 4
DA 2
DD 7
DE 3
DG 6
DH 5
DL 5
DN 4
DT 4
DY 3
E 2
EC 2
EH 6
EN 2
EX 5
FK 7
FY 5
G 6
GL 4
GU 3
HA 2
HD 4
HG 5
HP 2
HR 4
HU 4
HX 4
IG 2
IP 2
IV 7
KA 6
KT 2
KW 7
KY 7
L 4
LA 5
LD 5
LE 2
LL 6
LN 3
LS 4
LU 1
M 4
ME 3
MK 1
ML 6
N 2
NE 5
NG 2
NN 1
NP 4
NR 2
NW 2
OL 4
OX 2
PA 6
PE 2
PH 7
PL 6
PO 3
PR 5
RG 3
RH 3
RM 2
S 3
SA 5
SE 2
SG 1
SK 4
SL 2
SM 2
SN 3
SO 3
SP 3
SS 2
ST 3
SW 2
SY 3
TA 5
TD 6
TF 3
TN 3
TQ 6
TR 6
TS 5
TW 2
UB 2
W 2
WA 4
WC 2
WD 2
WF 4
WN 4
WR 2
WS 2
WV 3
YO 5




"martin" wrote:

i have a list of postcodes that i need to be able to pre select the
zone ie
1-10
example
AB = 1
PE = 3

Hi Martin

Assuming your data to be in cells A1:B117 and the postcode you are
looking to match a zone to in D1, then in E1 put the following formula


=VLOOKUP(D1,$A$1:$B$117,2,0)

Change the ranges and cell refernces to suit your data


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=465872

Thankyou paul

"Paul Sheppard" wrote:


martin Wrote:
Thanks Paul
When I recieve data i need the postcde to automaticaly select the zone
Please see below of the specific postcodes and their Zone, ie AB is
zone 7


AB 7
AL 2
B 2
BA 4
BB 5
BD 4
BH 4
BL 4
BN 3
BR 2
BS 4
CA 5
CB 1
CF 5
CH 4
CM 2
CO 2
CR 2
CT 3
CV 2
CW 4
DA 2
DD 7
DE 3
DG 6
DH 5
DL 5
DN 4
DT 4
DY 3
E 2
EC 2
EH 6
EN 2
EX 5
FK 7
FY 5
G 6
GL 4
GU 3
HA 2
HD 4
HG 5
HP 2
HR 4
HU 4
HX 4
IG 2
IP 2
IV 7
KA 6
KT 2
KW 7
KY 7
L 4
LA 5
LD 5
LE 2
LL 6
LN 3
LS 4
LU 1
M 4
ME 3
MK 1
ML 6
N 2
NE 5
NG 2
NN 1
NP 4
NR 2
NW 2
OL 4
OX 2
PA 6
PE 2
PH 7
PL 6
PO 3
PR 5
RG 3
RH 3
RM 2
S 3
SA 5
SE 2
SG 1
SK 4
SL 2
SM 2
SN 3
SO 3
SP 3
SS 2
ST 3
SW 2
SY 3
TA 5
TD 6
TF 3
TN 3
TQ 6
TR 6
TS 5
TW 2
UB 2
W 2
WA 4
WC 2
WD 2
WF 4
WN 4
WR 2
WS 2
WV 3
YO 5




"martin" wrote:

i have a list of postcodes that i need to be able to pre select the
zone ie
1-10
example
AB = 1
PE = 3

Hi Martin

Assuming your data to be in cells A1:B117 and the postcode you are
looking to match a zone to in D1, then in E1 put the following formula


=VLOOKUP(D1,$A$1:$B$117,2,0)

Change the ranges and cell refernces to suit your data


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=465872