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.
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:
If I want to google “beexcellence“, the following URL does the job:
Did you see that, the prefix for the search URL is constant:
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:
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.