how to search google using cell values in microsoft excel 2010

This must be so basic, so sorry to come up with such a simple query.
I know it's possible, I found 2 examples of syntax, but neither works for me, argh.

I have 3 columns of search terms, separated by or fields, like
bob or mary
tim or mike
claire or susan

In a 4th column, I want to combine those terms into a single search hyperlink to Google, separated by "and" fields. So first search would be for
"(bob or mary) AND (tim or mike) AND (claire or Susan)".
Plan is to click on the link and the search will come up in a separate browser window. May have to click search again to get actual search to run at this point, but that is a minor inconvenience. And anyway, I'm advised that Google will ban my IP if the search looks too automated; have to look thru the results manually, anyway.

I can get a search to work with plain text, so this syntax works:

=HYPERLINK("http://www.google.com/search?hl=en&q=boo ","Google Search")

But trying to put cell string values instead of "boo" is defeating me. I just don't understand right syntax and copying other people's syntax isn't working, either.
I've tried !s and #s and plenty of &s.

What is right syntax? Please help!!

mmm, maybe I'm not being clear. I mean, I don't need to search for boo, lol.

My fields are in columns A, B & C, row1.
I want column D to be a hypertext link that looks something like

=HYPERLINK("http://www.google.com/search?hl=en&q="&a1&" AND "&b1&" AND "&c1&,"Google Search")

which sends the search to google = "(bob or mary) AND (tim or mike) AND (claire or Susan)"

but that isn't the right syntax, either, to search for what is in cells a1-c1.

Separate problem, Do I need to put one string value per cell, too? So Cell A1 can't contain
"bob or mary" but it has to just say bob, and cell a2 would say mary?

Ooh, brilliant, thanks so much, good start. I had to tweak it slightly and got something that works now with a single cell:


=HYPERLINK("http://www.google.com/search?hl=en&q="&B1,"This search works perfectly but only with one cell for input")

So how do I get the same link to work but referring to Cells B1-D1? What is the syntax, anyone know?

Thank you so much, I think I have working syntax now. But I have hit a new limit which explains why I was struggling so much before. The actual search alternatives in each cell are a much longer list of words than "mary or tim" -- and basically they are too long. There is a limit to the number of combined characters I can put in.
I may well have to separate out my search terms to get reliable links (& to get the correct AND/OR combinations anyway).
Separating out terms will take long time.
Of course the boss wanted this all done yesterday, argh.
Thanks so much for the help!!