Creating Simple Excel Search Query

[stevedes7]

I'm in the process of creating what I thought should be an easy excel search query, but I seem to be having a bit of trouble with the programming language.

To make it simple:

I want to be able to have a list of search terms in excel in the first column of my spreadsheet (A1, A2, A3, etc), and then in the second column (b1, b2, b3), have correlating links to a Google search for those terms.

Just a quick illustration...

A ________________________B_______________________________________________
1. poker __________________1. http://www.google.com/search?q=poker
2. 2plus2__________________2. http://www.google.com/search?q=2plus2
3. ny giants________________3. http://www.google.com/search?q=ny giants
4. pokerstars_______________4. http://www.google.com/search?q=pokerstars
5. family guy_______________5. http://www.google.com/search?q=family guy

My issue is that I can't figure out what to put in after "search?q=***" as the *** to direct excel to read the A column. I've tried =google.com/search?q="A1"
=google.com/search?q=A1
=google.com/search?q=[A1]
google.com/search?q=A1

None of these have worked. Thanks for the help in advance.

[JBeaucaire]

In B1 put this formula and copy down:

=HYPERLINK("http://www.google.com/search?q=" & A1)

[stevedes7]

Awesome. Thanks so much.

And just to add to that. If there are actually 2 parameters in the query-

For example, http://www.google.com/search?q=poker&y=LasVegas , where Poker was the first parameter, and Las Vegas was the second parameter (location)

If Poker was A1, and Las Vegas B1, what would I write in C1 to refer the cell to the previous 2.

[JBeaucaire]

Well, the answer to your formatting question is:

=HYPERLINK("http://www.google.com/search?q=" & A1 & "&y=" & B1

That creates a link to match your layout, but Google doesn't respond properly when I do that. To get both terms to work in a search I did this:

=HYPERLINK("http://www.google.com/search?q=" & A1 & "+" & B1)