Searching Google based on an Excel database

Hi all,

I've been trying to find a thread or post in this regard but couldnt find one so thought woul start a new one. Is there a way for me to use one of the columns in my excel database as a search string and have top result populate in an adjacent column?

Basically I have a list of my customers who are doctors (one of the columns being their phone number). I have been googling their phone number (unique identifier) to see if they have a website, if they are actively marketing, etc. Now I was thinking if there was a way to automate this process?

I googled and came across with the googlelookup function in Google Docs. But that doesnt return any value.

Any thoughts?

Thanks!

Forum search produced

http://www.excelforum.com/excel-prog...via-excel.html

Originally Posted by royUK

Forum search produced

http://www.excelforum.com/excel-prog...via-excel.html

Thanks Roy...

I read through that thread and it did help, in that it opened up a bunch of options for my particular problem. That being said, what I am trying to accomplish is slightly different that e4excel's problem.

Please allow me to expand:
I have a database of 4000 customers(doctors) with the following fields (Name, Address, City, Phone, Website).
I have been tasked with the following -
1) Use the phone number of each of these customers and perform a google search
2) See what results pop-up (top 5-10) and identify if any of the results is the customer's (doctor's) own website.
3) If yes, then copy the link of the url to the website column in my database.

I understand this is a highly customized task but I was hoping some code could be written to accomplish this. Let me know your thoughts. Thanks a ton!!