Build Dynamic Google Search Link Using Google Sheets

1
votes

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.

1
google-sheetshyperlinkgoogle-sheets-formulaarray-formulasgoogle-finance
you mean like: google.com/search?q=AAPL ? - player0
yes like that but using the symbol in cell a1 to create the full link in cell b1 - westman2222

1 Answers

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

enter image description here

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

0

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

enter image description here

=GOOGLEFINANCE(A1, "price")

enter image description here