Hi,
Hoping someone can help, I have found similar questions on here but none exactly the same and the existing ones don't seem to match what I need to do.
I have a spreadsheet with over 1000 IP ranges listed on it and another sheet with thousands of IP addresses. I need to find the range name and subnet for the IP address from the list of ranges.
Some of my ranges are split so I cannot just focus on the first 3 parts of the IP.
Example:
IPrange.JPG
I then have a list of addresses and need to find them in the ranges and return the Subnet, VLAN name and Status against that address
10.194.23.10 and I need to find all the above info.
10.194.24.245
so I need to lookup the IP between A2 & B7 and return the values for Collumn C, D & E etc.
I tried a few examples on here but cannot think how I can do it when I have so many ranges to cater for (around 1000 different ranges).
Can anyone help
thanks in advance
Bookmarks