Hi.

I've got a list of M25 postcode sectors on a sheet called Postcode List
- M25e.g

EC1
EC2
EC3
EC4
WC1
WC2
N1
N2
N3
N4
N5

I have this formula in col I with formulas going up to M with Left
lookup value going up by one e.g left 2, left 3 etc. Then a if
statement to say true or false for inside M25.

attached are some sample postcodes

CF71 7UD
GU14 0LG
SK4 3EA
KT2 5LZ
N5 1LH - M25
SM4 4ST
BD8 0LZ

=IF(ISERROR(VLOOKUP(LEFT($A2,2),'Postcode List -
M25'!$A$1:$A$258,1,0)),"No",(VLOOKUP(LEFT($A2,2),' Postcode List -
M25'!$A$1:$A$258,1,0)))

Is there an easier way to do this

Any help or ideas would be good

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=567890