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 doesn’t work on Excel most of the time at current job...... 🤔 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.

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.