+ Reply to Thread
Results 1 to 5 of 5

ImportHTML

  1. #1
    Registered User
    Join Date
    09-25-2018
    Location
    NJ, United States
    MS-Off Ver
    2016
    Posts
    18

    ImportHTML

    I'm trying to pull information from a website using the importhtml function:


    And it works, but there's a spot on the web site to search a zip code...How can i factor that zip code into the formula?
    When i click search on the zip code, the website url stays the same...

    Please message me, I cannot paste the URL website into the thread as I need to post a few times on the forum..

  2. #2
    Registered User
    Join Date
    09-25-2018
    Location
    NJ, United States
    MS-Off Ver
    2016
    Posts
    18

    Re: ImportHTML

    Morning all, anyone able to assist?

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: ImportHTML

    You can type out the url instead of copying and pasting. Do not use the http://www when you type the address
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    09-25-2018
    Location
    NJ, United States
    MS-Off Ver
    2016
    Posts
    18

    Re: ImportHTML

    newjerseygasprices.com/GasPriceSearch.aspx is the website...

    anyone i can add a populated search function for a certain zip code into the importhtml ??

  5. #5
    Registered User
    Join Date
    09-25-2018
    Location
    NJ, United States
    MS-Off Ver
    2016
    Posts
    18

    Re: ImportHTML

    Still looking to see if there's a way to figure this out...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. ImportHTML to auto fresh in Sheets
    By Beh162 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2017, 09:52 AM
  2. pull information from website in gdoc via importxml or importhtml formula
    By krisskrossabc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-16-2017, 10:30 AM
  3. Issues with IMPORTHTML in Google Sheets
    By JoshS0515 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-14-2016, 12:39 PM
  4. ImportHTML Formula Help
    By oyz79 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2013, 10:08 AM
  5. ImportHTML (not the entire table)
    By Junka in forum Excel General
    Replies: 1
    Last Post: 06-06-2009, 09:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1