Hyperlink formula needs tweeking

[JRudman]

Hi,

Not sure if this is the correct place to post, but need help correcting my formula. I'll explain...

I have an excel of over 1000s companies that I need to individually get the website address for, so far I have used the Hyperlink forumla and a google search url to bring up a hyperlink that when clicked on takes me straight to the google search of that company... for example...

Company Name
Apple

Company Website
=HYPERLINK("http://www.google.com/search?hl=en&q=" & A2 & "&btnG=Google+Search")

Which takes me to this url http://www.google.com/search?hl=en&q...=Google+Search

I don't actually want it to take me to the google search, I want it to pull the first webiste address it finds on the google search (in the same way Google's "I'm feeling lucky" button works).

So my question is.... Does anyone know how to tweek this formula so that it returns the first result on the google page?

[martindwilson]

have you tried
=HYPERLINK("http://www.google.com/search?q="&A1&"%22&btnI=I%27m+Feeling+Lucky")

[JRudman]

Perfect, thank you.