Send a cell content to Google search

This is a continuation of previous post, in which I talked about the potential use of Smart Lookup for an Excel  dashboard.  However there is limitation.  It drove me to think of an alternative.

Instead of asking user to trigger Smart Lookup, I created a dynamic hyperlink that sends user to Google Search result based on the content in a cell.

Excel Tip - Smart Lookup or Google it1

Here’s come this post.

In order to achieve this, I googled a bit to find out the URL I need for a google search result, which is indeed quite simple.

For example, if I want to google “wmfexcel“, the following URL would do:

https://google.com/search?q=wmfexel

Excel Tip - Dynamic hyperlink to google search

If I want to google “beexcellence“, the following URL does the job:

Excel Tip - Dynamic hyperlink to google search2

 

Did you see that, the prefix for the search URL is constant:

https://google.com/search?q=

 

Excel Tip - Dynamic hyperlink to google search1

The variable part is the text string that being joined after the “=” sign.  In our examples, wmfexcel and beexcellence are the variables.

Once we’ve find this pattern, it is easy in Excel to create the dynamic URL using HYPERLINK function:

The Syntax

HYPERLINK(link_location, [friendly_name])

Here we go:

=HYPERLINK("https://google.com/search?q=" & A1,"Google "& A1)
where A1 resides the content you want to google about

The logic is straight forward.  We concatenate the prefix URL with the search content that resides in a cell, followed by giving it a user-friendly name.

As simple as this. 🙂

Try it out.  Hope you like it.

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Formula and tagged . Bookmark the permalink.

6 Responses to Send a cell content to Google search

  1. Kiền Nguyễn says:

    Amazing, saves me so much time. Thank you for that. Can I ask how I can automatically put the link of the first search result in another cell?

    Like

    • MF says:

      You are welcome. Glad that it helped. And you have a very good question… which I don’t have an answer. 😅. Hope there will be answers from other experts.

      Like

  2. Michael Wolf says:

    Wow, this is amazing! Going to save me tons of time on my project! Thank you so much!

    Like

  3. twinkle says:

    what if we have spaces in the string ?

    Like

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.