I know this works:

= hyperlink( "https://www.google.com/search?q=" & B2 )

But I can't get two variables to work so the link would look like:

https://www.google.com?var1=[insert cell contents]&var2=[insert cell contents]

Any suggestions?

  • You say it doesn't work - what does it do when you try? – MaryC.fromNZ May 4 '14 at 23:46
= hyperlink( "https://www.google.com/search?q=" & B1 & "&var2=" & C1 )

This works for me.

  • Works for me too, thanks. Not sure why someone down voted it. – OahuRE May 3 '14 at 18:11

As I understand your question

= hyperlink( "https://www.google.com/search?q=" & B2 & C2)  

should suit. However, since the example you give is for a Google search and Google ignores punctuation in search terms (probably for the best!) (see and tag wiki for [google-search]) there may be no need for two variables. Ie string terms together within B2 thus:


So with that and paris in C2 and metro in D2 took me to https://www.google.com/search?q=parismetro.

  • I just used Google as the URL as it came to mind for the example, this is not for a Google Search. I need to have the var2= before the 2nd variable. – OahuRE May 3 '14 at 18:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.