|
formula
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 |
| All times are GMT +1. The time now is 09:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com