Help with Addresses
 

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


--
kimbiak21
------------------------------------------------------------------------
kimbiak21's Profile: http://www.excelforum.com/member.php...o&userid=33423
View this thread: http://www.excelforum.com/showthread...hreadid=532394

Help with Addresses
 

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

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"kimbiak21" wrote
in message ...

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


--
kimbiak21
------------------------------------------------------------------------
kimbiak21's Profile:
http://www.excelforum.com/member.php...o&userid=33423
View this thread: http://www.excelforum.com/showthread...hreadid=532394

Help with Addresses
 

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"kimbiak21" wrote in message
...

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


--
kimbiak21
------------------------------------------------------------------------
kimbiak21's Profile: http://www.excelforum.com/member.php...o&userid=33423
View this thread: http://www.excelforum.com/showthread...hreadid=532394

Help with Addresses
 

You must set up a table (maybe in another worksheet) that lists all towns
and corresponding zip code.

Then you can use a VLOOKUP formula to retrieve zip code given a town name.

See example: http://cjoint.com/?emvbMwu3jj

HTH
--
AP

"kimbiak21" a écrit
dans le message de
...

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


--
kimbiak21
------------------------------------------------------------------------
kimbiak21's Profile:
http://www.excelforum.com/member.php...o&userid=33423
View this thread: http://www.excelforum.com/showthread...hreadid=532394

Help with Addresses
 

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.


--
kimbiak21
------------------------------------------------------------------------
kimbiak21's Profile: http://www.excelforum.com/member.php...o&userid=33423
View this thread: http://www.excelforum.com/showthread...hreadid=532394

Help with Addresses
 

The column needs to be in the lookup range. Try

=VLOOKUP(Sheet1!E430,Sheet2!$A$1:$G$26,7,FALSE)

In article ,
kimbiak21
wrote:

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.

Help with Addresses
 

Ooops, read it backwards. Use

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

but enter the formula in column 7 (G)


In article ,
kimbiak21
wrote:

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.

Help with Addresses
 

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


--
kimbiak21
------------------------------------------------------------------------
kimbiak21's Profile: http://www.excelforum.com/member.php...o&userid=33423
View this thread: http://www.excelforum.com/showthread...hreadid=532394

Help with Addresses
 

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"kimbiak21" wrote in message
...

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.