close

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: www.excelforum.com/member.php...oamp;userid=33423
View this thread: www.excelforum.com/showthread...hreadid=532394Hi 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 NOSPAMquot;kimbiak21quot; gt; wrote
in message ...
gt;
gt; Is this possible and if so how do I go about it. I am typing addresses
gt; into fields in excel and I was wondering if I could get excel to fill
gt; in the zip code cell once the town cell was typed in?? Somewhere I
gt; would tell it what town goes to what zip code??
gt; Any advice??
gt; Thanks,
gt; Kim
gt;
gt;
gt; --
gt; kimbiak21
gt; ------------------------------------------------------------------------
gt; kimbiak21's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33423
gt; View this thread: www.excelforum.com/showthread...hreadid=532394
gt;
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
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;kimbiak21quot; gt; wrote in message
...
gt;
gt; Is this possible and if so how do I go about it. I am typing addresses
gt; into fields in excel and I was wondering if I could get excel to fill
gt; in the zip code cell once the town cell was typed in?? Somewhere I
gt; would tell it what town goes to what zip code??
gt; Any advice??
gt; Thanks,
gt; Kim
gt;
gt;
gt; --
gt; kimbiak21
gt; ------------------------------------------------------------------------
gt; kimbiak21's Profile: www.excelforum.com/member.php...oamp;userid=33423
gt; View this thread: www.excelforum.com/showthread...hreadid=532394
gt;
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: cjoint.com/?emvbMwu3jj

HTH
--
AP

quot;kimbiak21quot; gt; a écrit
dans le message de
...
gt;
gt; Is this possible and if so how do I go about it. I am typing addresses
gt; into fields in excel and I was wondering if I could get excel to fill
gt; in the zip code cell once the town cell was typed in?? Somewhere I
gt; would tell it what town goes to what zip code??
gt; Any advice??
gt; Thanks,
gt; Kim
gt;
gt;
gt; --
gt; kimbiak21
gt; ------------------------------------------------------------------------
gt; kimbiak21's Profile:
www.excelforum.com/member.php...oamp;userid=33423
gt; View this thread: www.excelforum.com/showthread...hreadid=532394
gt;

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: www.excelforum.com/member.php...oamp;userid=33423
View this thread: www.excelforum.com/showthread...hreadid=532394The column needs to be in the lookup range. Try

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

In article gt;,
kimbiak21 gt;
wrote:

gt; Thanks for all your advice,
gt; So, I tried using the vlookup and here is the actual formula i put in
gt; the cell i want the zipcode entered into
gt; =VLOOKUP(Sheet1!E430,Sheet2!$A$1:$B$26,7,FALSE)
gt; Sheet1!E430 is the cell the town is entered into Sheet 2!$A$1:$B$26 is
gt; the table of towns and zips, 7 is the column I want the zip entered
gt; into.
gt; It doesn't work. Any thoughts as to what I am doing wrong???
gt; Thanks again,
gt; Kim
gt; btw - I understand the city to zipcode, zipcode to city, but for what
gt; I am inputing it will work for me this way.

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 gt;,
kimbiak21 gt;
wrote:

gt; Thanks for all your advice,
gt; So, I tried using the vlookup and here is the actual formula i put in
gt; the cell i want the zipcode entered into
gt; =VLOOKUP(Sheet1!E430,Sheet2!$A$1:$B$26,7,FALSE)
gt; Sheet1!E430 is the cell the town is entered into Sheet 2!$A$1:$B$26 is
gt; the table of towns and zips, 7 is the column I want the zip entered
gt; into.
gt; It doesn't work. Any thoughts as to what I am doing wrong???
gt; Thanks again,
gt; Kim
gt; btw - I understand the city to zipcode, zipcode to city, but for what
gt; I am inputing it will work for me this way.


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: www.excelforum.com/member.php...oamp;userid=33423
View this thread: www.excelforum.com/showthread...hreadid=532394Hi 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:
www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;kimbiak21quot; gt; wrote in message
...
gt;
gt; Thanks for all your advice,
gt; So, I tried using the vlookup and here is the actual formula i put in
gt; the cell i want the zipcode entered into
gt; =VLOOKUP(Sheet1!E430,Sheet2!$A$1:$B$26,7,FALSE)
gt; Sheet1!E430 is the cell the town is entered into Sheet 2!$A$1:$B$26 is
gt; the table of towns and zips, 7 is the column I want the zip entered
gt; into.
gt; It doesn't work. Any thoughts as to what I am doing wrong???
gt; Thanks again,
gt; Kim
gt; btw - I understand the city to zipcode, zipcode to city, but for what
gt; I am inputing it will work for me this way.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()