Lookup City and County to corresponding zip code

H

hkg003

Active Member
Joined
Apr 6, 2008
Messages
257
Hello,
I am trying to find a way to add the city and county to match the zip code and state. I have sheet 1, column A listing the zip codes, Column C listing the state. I am wanting column B to list the City corresponding with the zip code in column A and the county in column D to match with the City in column B with the data provided in Sheet 2.

In sheet 2, I have the zip codes listed in column A, City for column A listed in Column B, State listed in Column C and county listed in column D.

I would paste my worksheet but I do not know how.


Any help on this would be deeply appreciated.


Thanks
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
Do you mean Sheet1 is extracted information from Sheet2, while if Zip Codes are matched, City, State and Country should match as well?

If so, simply try vlookup:

Type in B2 (suppose you have title in Row 1):

=VLOOKUP(A2,Sheet2!A:D,2,)

while in D2, input =VLOOKUP(A2,Sheet2!A:D,4,)

Hope this will help.
 
Upvote 0
Hello idleward,
Thanks for the reply. I typed in the formula you sent and I receive #N/A in all of the columns. What am I doing wrong?

And yes, row 1 contains titles


Thanks for your help!
 
Upvote 0
Example of my worksheet.....I hope I did this right!!


I am having a hard time posting my worksheet
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question
creating Zip files from the list of files in Excel file
Replies
1
Views
108
John_w
J
T
  • Question
Concatenate Name and Address from the Specific Row(s) that Matched Data Validation List Selections
Replies
1
Views
157
DanteAmor
DanteAmor
E
  • Question
Can you do an API call in Excel using VBA?
Replies
2
Views
304
John_w
J
S
  • Question
UPS API Transit Time
Replies
0
Views
344
steveolb
S
S
  • Question
Assigning a zip code off of a column or columns
Replies
1
Views
295
awoohaw
awoohaw

Forum statistics

Threads
1,215,381
Messages
6,124,614
Members
449,175
Latest member
Anniewonder

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top