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? Commented May 4, 2014 at 23:46

2 Answers 2

= 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
    Commented May 3, 2014 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
    Commented May 3, 2014 at 18:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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