Web hyperlink in excel based on cell value? e.g. http://google.com/searchq=(a1)

[EvoUK]

Hi,

I am aware excel can create URL to websites.
However, is it possible to create a hyperlink to a website but specify a section of the URL based on data within a particular cell? Similar to how excel formulas function based on specifying particular cells but for web hyperlinks.

E.g. the initial URL is

Google

Search the world's information, including webpages, images, videos and more. Google has many special features to help you find exactly what you're looking for.

www.google.com

and cell A1 is
bird

then the URL will become

bird - Google Search

And as the A1 data changes, the ending suffix of the hyperlink will update accordingly.

I'm sure there probably is an easy way to do this but I have been struggling to find any methods explaining the process.
Any help would be appreciated.

 

[Kerryx]

=HYPERLINK("http://www.google.com/search?q="&A1&"&safe=active",A1&" - Google Search")

 

[EvoUK]

=HYPERLINK("http://www.google.com/search?q="&A1&"&safe=active",A1&" - Google Search")

Thanks, thats exactly what I was looking for.

 

[Kerryx]

glad to help

 

[EvoUK]

Thanks, thats exactly what I was looking for.

Hi,

Follow up on my previous request.

Is it possible to use the same hyperlink formula (hyperlink based on variable data within a cell) on an object/image in excel?

I tried applying the same formula onto an image but received an error stating something was missing.

 

[Kerryx]

Sorry beyond my level of knowledge but would guess there is a vba option available , problem i see is that doing a reverse image lookup via google anyway is that it is a 2 step process in that (1)you have to load the image to the image search (2) this generates an ID of some sort that is used for the search.

image search.xlsx
	A	B
1	bird	bird - Google Search
2	bird	bird -Google image search
3
Sheet1

Cell Formulas
Range	Formula
B1	B1	=HYPERLINK("http://www.google.com/search?q="&A1&"&safe=active",A1&" - Google Search")
B2	B2	=HYPERLINK("https://www.google.com/search?q=" & A2 &"&tbm=isch",A2&" -Google image search")

 

[EvoUK]

Sorry beyond my level of knowledge but would guess there is a vba option available , problem i see is that doing a reverse image lookup via google anyway is that it is a 2 step process in that (1)you have to load the image to the image search (2) this generates an ID of some sort that is used for the search.

image search.xlsx
	A	B
1	bird	bird - Google Search
2	bird	bird -Google image search
3
Sheet1

Cell Formulas
Range	Formula
B1	B1	=HYPERLINK("http://www.google.com/search?q="&A1&"&safe=active",A1&" - Google Search")
B2	B2	=HYPERLINK("https://www.google.com/search?q=" & A2 &"&tbm=isch",A2&" -Google image search")

Hi,

Thanks for getting back to me.

Apologies, I probably didn’t explain my previous question properly.

The formula you provided earlier works perfectly and was exactly what I was after (e.g. the weblink updating based on the end prefix defined in a specific cell).

=HYPERLINK("http://www.google.com/search?q="&A1&"&safe=active",A1&" - Google Search")

However, the issue I currently have is that when I access the spreadsheet via a mobile device, I struggle to get the weblink to open.
This doesnt seem to be an issue if I add the link to an image button (e.g. a graphical shape) and the weblink seem to open easily/fine everytime I click on it.

Is is possible to apply the hyperlink formula or a varient of it to a shape/image within the excel document (e.g. the blue box in the image below) as opposed to the weblink/URL being applied to a text link?

 

[Kerryx]

Vba not my best but this is probably close to what you want you can get rid of the text option then and just use button

Testbutton.xlsm
	A	B	C
1	bird	bird - Google Search
Sheet1

Cell Formulas
Range	Formula
B1	B1	=HYPERLINK("http://www.google.com/search?q="&A1&"&safe=active",A1&" - Google Search")

Add the following code

Private Sub CommandButton1_Click()
ActiveWorkbook.FollowHyperlink _
Address:="http://www.google.com/search?q=" & Range("A1")
End Sub

Adjust button colour and text in properties

 

[EvoUK]

Awesome, works great! Thanks again!