Use VLOOKUP. Create your list of zip codes and cities on a tab used for
just that list.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=511390