Hello,

I have a wierd question. And I don't know if this is even possible or not, but I'll ask anyway.

I have an Excel Worksheet that has a customer field, (column C), & a address field (Column E) & a zip code field column H, In column M I designated a
(website) field.

My question is: I want to use the customer field, plus address field plus zip code all three fields together as one search query in Google, and have return back the URL of the first site that google returns (like hitting the I'm feeling lucky button) and insert that back into the column M.

Is this possible?

ex: col c = Boeing, column E = 100 N Riverside plz
column H = 60606, then either using a formula, or a macro ,
somehow let the computer process these fields and return
http://www.chicagoarchitecture.info/...adquarters.php
as the URL into column M.

basically if you go to google, paste in:
Boeing 100 N Riverside plz 60606 AND then hit the I'm feeling lucky button you get
http://www.chicagoarchitecture.info/...adquarters.php


IS there a way to automate this?? (becuase I have 31000+ rows and would like the computer to do it instead? thanks





Thanks
Bo


BTW I already have this formula working in

excel:=HYPERLINK("http://www.google.com/search?hl=en&q=" & C7 & "+ " & E7 & "+" & H7 & "&btnG=Google+Search", C7)


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

what this does is return the google search URL back into the excel, so when I click on it it shows the google search results page for that customer, but what if I want it to show the ACTUAL FIRST WEBSITE that google points to instead of the goolge results page? How is this accomplished?