Build Dynamic Google Search Link Using Google Sheets

Question

I am hoping to create a column in Excel that links to a Google search for a specific stock depending on the stock symbol in column A. For instance if column A1 = AAPL,

b1 would be:

Using the Symbol in A1, cell b1 will create a link that makes Google search. I know this can be done in google sheets but I'm not sure of the exact syntax.

yes like that but using the symbol in cell a1 to create the full link in cell b1 — westman2222, Jun 25 '19 at 00:49

player0 · Accepted Answer · 2019-06-25T01:04:38.973

0

="https://www.google.com/search?q="&A1

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

=ARRAYFORMULA(HYPERLINK("https://www.google.com/search?q="&A1:A2, 
 "search for "&A1:A2))

=GOOGLEFINANCE(A1, "price")

edited Jun 25 '19 at 01:04

answered Jun 25 '19 at 00:55

player0

124,011
12
67
124

1

you have been quite helpful to me this week! – westman2222 Jun 25 '19 at 01:06

Build Dynamic Google Search Link Using Google Sheets

1 Answers1