I am trying to do the opposite. I have a list of domain names in col. a2-? and I want to use a vba macro to have it lookup the web server ip and mail server ip and paste web ip to b2-? and mail to c2-? Any ideas , oh and I need to have it lookup against 3 internal dns servers.