I have a list of zip codes that I need attach zone numbers to. I wish
it were as easy as saying all zip codes from 00001-20000 = zone 1,
20001-40000 = zone 2...but they're all over the place.

So, I'd need to do something like zone = 1 if (000-003) or (588-595) or
770-778) or etc.

So I have one column that gives the zone number and another column that
gives the first three digits of the zip code.

Any ideas?

Thanks


--
rockofaith
------------------------------------------------------------------------
rockofaith's Profile: http://www.excelforum.com/member.php...o&userid=34494
View this thread: http://www.excelforum.com/showthread...hreadid=542599