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

Seasonal Holidays 2024

Happy Holidays! #GoogleDoodle

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!