+ Reply to Thread
Results 1 to 3 of 3

Hyperlink Using Google to Conduct Searches

  1. #1
    Registered User
    Join Date
    03-20-2018
    Location
    Miami, FL USA
    MS-Off Ver
    2013 Excel
    Posts
    2

    Hyperlink Using Google to Conduct Searches

    Good Day,

    Please and thank you for any help offered.
    I think this should be fairly simple for an experienced Excel user, I am not.

    Basically I have the following spreadsheet:

    A1 has the symbol "
    A2 would be where the user enters text, typically this is a person's or business name; such as GoingProPro Inc.
    A3 has the symbols " +
    A4 has some verbiage used; such as TROUBLE or CRIME or ARREST
    A5 is a concatenate formula putting everything together; "GoingProPro Inc." + TROUBLE or CRIME or ARREST

    I want A6 to be a hyperlink to google searching A5

    I have the following formula:
    A6 is =hyperlink("GOOGLE/search?q="&A5, "Google Search"). Please note this is my first post and excelforum doesn't allow me to post links.. GOOGLE is a placeholder for their domain name.

    I also tried /search?num=50&site=&source=jp&q=
    I also tried /search?num=40&ei=nRCxWumiBIHwzgKClqjgDA&q=
    I've tried whatever google spits out after their website domain name. I'm guessing these are different servers but I don't know to be honest.

    Sometimes, when I click the link an error window prompts stating something is invalid.
    Other people I work with say the link most often than not doesn't work and they too are prompted with the error message window.

    Can someone please teach me the right way of setting this up so that no error messages are prompted.

    Thank you and Regards,

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Hyperlink Using Google to Conduct Searches

    how about this?
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    p.s. i found this website quite helpful in addressing this request. https://moz.com/blog/the-ultimate-gu...rch-parameters
    Last edited by simarui; 03-20-2018 at 10:56 AM.
    Hope I could help - if your post has been solved don't forget to mark it as such.

    Clicking the * below is a great way to say thanks!

    "Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito

  3. #3
    Registered User
    Join Date
    03-20-2018
    Location
    Miami, FL USA
    MS-Off Ver
    2013 Excel
    Posts
    2

    Re: Hyperlink Using Google to Conduct Searches

    Thanks, I'll look into it.

+ 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. Using VBA for extracting data from specific Google Searches
    By cfc06 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-14-2016, 11:50 AM
  2. Is there a way to automate google searches into excel?
    By Marine27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2016, 04:18 PM
  3. [SOLVED] Need A Macro That Automaticly searches files in desktop to find .dwg file to hyperlink too
    By Eaaron in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-09-2015, 04:49 PM
  4. Is there a way to automate google searches into excel?
    By bxc2739 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-25-2013, 02:31 AM
  5. hyperlink for google maps
    By tlynchjr@aol.com in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-06-2013, 05:48 PM
  6. Hyperlink that searches for a word in a cell in another sheet
    By nscalet in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-30-2012, 12:32 PM
  7. Excel 2007 : Excel Data Variable/Hyperlink Searches
    By MudPuppy in forum Excel General
    Replies: 8
    Last Post: 08-08-2011, 09:27 AM

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