How can I get a postal code in a cell - from the internet?

G

Guest

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.
 
G

Guest

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 "address", "city" and "state" cells and extract the information from
another place and insert it into the cell?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top