• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Please help

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
 
Hulkster1017

I have assumed that A1 has a Title Zip and B1 County and so the data starts in Row 2

Try something like this in D2

=+OFFSET($B$1,MATCH(C2,$A$2:$A$4000,0),0)

Change the value 4000 to the Row number of the bottom of the Zip code column

and copy it down
 
That will occur when the Zip you are looking up isn't in the list of Zip Codes

Check that there aren't any leading or trailing spaces in both lists of Zip Codes

Or if there are internal spaces, make sure they are all a single character
 
Back
Top