Hello,
I have a list of zip codes (Col A) and district codes (Col B) in worksheet "Zips". I have another sheet "City" has list of zip codes (Col A) and the associated city names, county & state (Col B, C & D respectively). I'm trying to do a vlookup to get the city name in the "Zips" worksheet from the "City" worksheet . However, there are duplicate values in Col A of the "Zips" worksheet and in the Col A of the "City" worksheet.
The vlookup gives me the city name which appears first in the array but not the subsequent city names if the zip code is duplicated. Is there a way to get the subsequent city names if the zip code is duplicated.
I've attached the workbook.
Your help is much appreciated.
Vinod
Bookmarks