Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question
    
You say it doesn't work - what does it do when you try? –  MaryC.fromNZ May 4 at 23:46

2 Answers 2

up vote 0 down vote accepted
= hyperlink( "https://www.google.com/search?q=" & B1 & "&var2=" & C1 )

This works for me.

share|improve this answer
    
Works for me too, thanks. Not sure why someone down voted it. –  OahuRE May 3 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:

=C2&D2

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

share|improve this answer
    
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 at 18:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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