Hoping somebody can assist me in solving the below problem - my XLSX file can be downloaded at: http://www.faithfold.com/download/zipcode_database.xlsx

I'm dealing with 4 columns of data (there are more in the file but only the first four are pertinent to the function). The columns, left to right, are: my zips, my cities, us zips, us cities.

Here is the scenario: I have a list (Column A) of zip codes that I need to match up with their corresponding cities. Column C is a much longer list of every zip code in the country, along with the corresponding city name adjacent to it, in Column D.

What I need Excel to do is look at the Zips in Column A, find the match in Column C, and then take the adjacent city name in Column D, and place that city name back in Column B... I hope that makes sense. In short, I just need to gather the correct city names that match my zips, and the data is there I just don't know how to manipulate it.

Thank you!