Hi.

I have 3 columns in an Excel worksheet.

The 1st column has the first IP address in a subnet.

The 2nd column has the last IP address in the subnet.

The 3rd column has the email address of the person responsible for the
subnet (a LAN admin).

Example:

IPStart ____ IPend ______ Admin
133.214.1.0 133.214.1.254
133.214.2.0 133.214.2.254

etc...

(underscores used for formatting on this post)

I run a scan every now and then on my network to see which computers
are not patched and I generate a list that I export into Excel in a
vertical column.

Example:

133.214.1.2
133.214.1.5
133.214.1.11
133.214.2.6
133.214.2.8

..etc.


I sort them in order. I would appreciate any assistance on how I can
write a formula or function to loop through each IP address in my scan
output and return an output that has the LAN admin's email address
(from the 3rd column) with all of the IP addresses that are within the
range assigned to that person.

So the output would be:


133.214.1.2
133.214.1.5
133.214.1.11

133.214.2.6
133.214.2.8

Thanks!





------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/