Google - I'm Feeling Lucky

B

billpq

Board Regular
Joined
Oct 19, 2004
Messages
106
How can I convert whatever text I have in Column A into a link in Column B such that when I click on the link, it will go to Google.com, enter my text from Column A, and then execute Google's "I'm Feeling Lucky" button so I go directly to the website that is the I'm Feeling Lucky result?

I'm aware of the Hyperlink() formulae, but am not sure how to get it to click on I'm Feeling Lucky.

Thanks.
 
Sort by date Sort by votes
If I type 'Kobe Bryant' into a Google search I get almost 12m results.

I also don't see this 'I Feel Lucky' link/button and I don't quite understand why you would use such a thing if you want/need specific data.:)
 
Upvote 0

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Stop the clock... I got it (I found elsewhere online)!

If you turn this into a hyperlink, it works (where the contents of cell A1 is what you are looking for):

="http://www.google.com/search?q="&A1&"%22&btnI=I%27m+Feeling+Lucky"

Thanks for all your questions and efforts!
 
Upvote 0
Norie... If you go to Google.com you don't see the "I'm feeling Lucky" button to the right of the Google Search button? It's been there for as long as I can remember. Anyway, like I said, I got it, and thanks for your help.
 
Upvote 0
Glad to seem you've got it sorted.:)

Mind you isn't that something along the lines of what I suggested in the first place?
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Covert web address to clickable link
Replies
6
Views
259
Pacman52
P
R
  • Question Question
Build Hyperlink from Cells in Another Workbook?
Replies
1
Views
349
Fluff
Fluff
O
  • Question Question
Using ascii code in Excel UserForm Textbox
Replies
4
Views
474
Akuini
Akuini
P
  • Solved
New Worksheet Hyperlinks
2
Replies
12
Views
243
Peter_SSs
Peter_SSs
T
  • Solved
Move cursor to a specific cell after data has been entered
Replies
4
Views
336
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,504
Messages
6,179,142
Members
452,892
Latest member
JUSTOUTOFMYREACH

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top