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