MrBorders,

You don't really need to use excel programming for this. There is a function(s) that can simply accomplish this task. For example, column A is your LOOKUP zipcodes, column C is a larger subset of zipcodes, column D is your corresponding city names, and column B is where you would like the city names to appear for each LOOKUP zipcodes.

In column B:
=INDEX(C1:D2,MATCH(A1,C1:C2,0),2)
What does this mean? C1:D2 can be expanded to cover all your larger subset of zipcodes and corresponding city names. MATCH will return the position, and the range will be your column C, and specify 0 as you would want to have an exact match. To finish off, specify 2 at the end to retrieve the corresponding city name. Give this a twirl, and if you have any questions, let me know.

Cheers,
Jimmie D