Ip address lookup

[tcg2k5]

I have a list of domain names in spreadsheet that I am trying to write a macro for that so it will lookup using nslookup against 3 internal servers for the ip address of those domains and paste the results in another column and also paste the ip address of the mail server in yet another column.

So I have 3 columns.

A1 B1 C1
domain names web ip address mail server ip address

Does anyone know how to do this with a macro or any other command within excel?

 

[Tazguy37]

This post might provide some insight. HTH

 

[tcg2k5]

This post might provide some insight. HTH

Thanks but I looked already and without spending a week going through every thing , I dont see anything to help.