On Sat, 23 Aug 2008 14:00:00 -0700, shress
Try this formula in cell C1:
Sheet2 is the name of the sheet where you put all possible ZIP codes
in column A and the correspoonding Street names in column B.
Increase the 1000 if you data takes more than 1000 rows.
Hope this helps / Lars-舓e