software

I'm trying to insert a postal code into a spreadsheet based on the address
information we are given. I need a way to use the street address, city and
state to plug into a message to a lookup table on the internet so that I can
get the ZIP code back to insert into the correct cell on the spreadsheet.

Open:

zip4.usps.com/zip4/welcome.jsp

and enter the address information via VBA. The web page will return the 5 4
ZIP code which can then download.
--
Gary's Studentquot;DeanWHandyquot; wrote:

gt; I'm trying to insert a postal code into a spreadsheet based on the address
gt; information we are given. I need a way to use the street address, city and
gt; state to plug into a message to a lookup table on the internet so that I can
gt; get the ZIP code back to insert into the correct cell on the spreadsheet.

I knew about the USPS site - and I've used it before to do this manually -
but is there a way to do this lookup in a spreadsheet cell? That is to say;
can I put a formula into a cell in a spreadsheet that will take information
from quot;addressquot;, quot;cityquot; and quot;statequot; cells and extract the information from
another place and insert it into the cell?

quot;Gary''s Studentquot; wrote:

gt; Open:
gt;
gt; zip4.usps.com/zip4/welcome.jsp
gt;
gt; and enter the address information via VBA. The web page will return the 5 4
gt; ZIP code which can then download.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;DeanWHandyquot; wrote:
gt;
gt; gt; I'm trying to insert a postal code into a spreadsheet based on the address
gt; gt; information we are given. I need a way to use the street address, city and
gt; gt; state to plug into a message to a lookup table on the internet so that I can
gt; gt; get the ZIP code back to insert into the correct cell on the spreadsheet.