How to lookup an IP address in an Excel spreadsheet?

How to lookup an IP address in an Excel spreadsheet? I'm working with a decent sized spreadsheet of domains and server names. Another user of the spreadsheet needs the IP address for each of the DNS entries on the worksheet. Instead of manually adding and then having to maintain this list, is there an easy way to do an IPAddress lookup to display the IP address in a cell?
Asked by: Guest \| Views: 340

Total answers/comments: 1

Comments display order:

bert [Entry]

"Try visiting this site. Probably you'll need to adapt more than on script to fit all your needs.

For instance, this script will retrieve the IPs for an entire DNS server. You could adapt it walk an excel spreadsheet and retrieve just the ones that you need."