Hi,

I have a ton of DNS names for a lot of computers (servers, routers, switches, firewalls, etc.) in 1 spreadsheet, and I need to associate those names to IP addresses.

There are 2 spreadsheets I have at the moment.

One consists of the DNS name of the devices in many worksheets, but no IP addresses.
Other consists of both DNS name and IP address (so it is associated already).

But I need to somehow populate the 1st spreadsheet with the IP address (alongside the DNS name).

There are around 4000 devices listed, and those DNS names are all over the place.

Ideally, I'd like to have a column inserted adjacent to DNS name, with correct IP address.

Any ideas?

Many thanks!