hulkster1017
New Member
I have an excel worksheet that has 3 columns. In Column A has a list of all US zip codes, column B has a list of US counties that correspond to Column A. Column C has a list of zip codes that corresponds to an address list that has about 12000 people. I would like to generate a fourth Column, it will be a list of Counties that corresponds to Column C. how can i do this in excel. I want to compare column A and C and if C=A then generate column B into Column D. What type of formula do i need.
Thnks
Thnks