• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is there any way to pull city and state when you enter xip code in excel from we

Hi, sunnyp!

It all depends on your country and the websites available for consulting.

Regards!
 
I want to pull data from web suppose i enter a zip code in a cell so it will populate city and state automatically , how to pull this data from a web.
 
Sunnyp


Goto the Data, From Web tab

Put your web address in the URL Bar

When the page loads select the table that the info is on.


If the web site uses Lookup/Search boxes, you will need to use a different technique

Start by reading http://www.dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/


You would be better to download a file with all the data in it and then lookup within that file/data
 
Sunnyp


Please don't multiple post


People will get to this is they have the time/skill as they can.
 
You must log in or register to reply here.
Back
Top