Help with Addresses

  • Thread starter Thread starter kimbiak21
  • Start date Start date
K

kimbiak21

Is this possible and if so how do I go about it. I am typing addresses
into fields in excel and I was wondering if I could get excel to fill
in the zip code cell once the town cell was typed in?? Somewhere I
would tell it what town goes to what zip code??
Any advice??
Thanks,
Kim
 
Hi kimbiak21,

If the town was in it's own cell and you had a table setup in another
location which already had the towns and their respective zip codes, then
you could use a VLOOKUP formula to retreive the results you desire. The
basic syntax is as follows...

=VLOOKUP(A1,Lookup_Table,2,0)

Where A1 is the cell you're trying to find (town name) which must be in the
left-most column of your Lookup_Table. The 2 is the column to return on a
matched value, and the 0 specified an exact match (1 is an approximate).

HTH
 
Typing the US zip code would more accurately address the town then
typing the town would identify a zip code.

Pittsburgh, PA must have at least a hundred zip codes
and there is more than one Pittsburgh in the US most w/o the h

You can use VLOOKUP Worksheet Function
http://www.mvps.org/dmcritchie/excel/excel.htm
suggest you use the 5 text digits to determine the town
 
Thanks for all your advice,
So, I tried using the vlookup and here is the actual formula i put in
the cell i want the zipcode entered into
=VLOOKUP(Sheet1!E430,Sheet2!$A$1:$B$26,7,FALSE)
Sheet1!E430 is the cell the town is entered into Sheet 2!$A$1:$B$26 is
the table of towns and zips, 7 is the column I want the zip entered
into.
It doesn't work. Any thoughts as to what I am doing wrong???
Thanks again,
Kim
btw - I understand the city to zipcode, zipcode to city, but for what
I am inputing it will work for me this way.
 
The column needs to be in the lookup range. Try

=VLOOKUP(Sheet1!E430,Sheet2!$A$1:$G$26,7,FALSE)
 
Ooops, read it backwards. Use

=VLOOKUP(Sheet1!E430,Sheet2!$A$1:$B$26,2,FALSE)

but enter the formula in column 7 (G)
 
Ok so I get it to work on a new book but I have already inputed 430
names and addresses and want to continue on this same book, and I can't
seem to get it to work on this one starting at line 430 instead of line
1. I believe I am doing the same thing, but the E430 doesn't change in
each rows formula to say E431, etc... like it should and like it does
when I'm doing it from a new book and from line 1. I copy the formula
in G430 and then select that column down to like G1000 and do a Control
D. ??? Does this sound correct?
Thanks for being so patient with me,
Kim
 
Hi K......,

7 is the column I want the zip entered into.

The seven represents the column that the zip code comes from
you probably want that to be a 2 which is infect the dimension you\
provided in your table. table in Sheet2!$A1:$B$26

Remember a formula can only obtain a value, your formula
has to be placed into the cell that is to receive the value.

Examples:
http://www.mvps.org/dmcritchie/excel/vlookup.htm
 
Back
Top