Tech Support Forum banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter · #1 ·
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
Column A is titled US Zip Code
Column B is titled County
Column C is title adress zipcode
 

·
Folding Along
Joined
·
2,304 Posts
That would be an IF statement.

This sounds like a homework assignment, so I'm not going to give you more than that.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top