Hi everyone,
I'm trying to accomplish the following:
Have a some logic around checking an IP address against say 30 subnet ranges. We'll say Cell F2 has 10.1.1.1, I need to build something to check if that cell contains something in this range:
> 10.1.0.0 AND <10.1.255.255, "Insert Subnet Name", if not
is it > 10.2.0.0 AND <10.2.255.255, "Insert Subnet Name", if not
is it > 10.3.0.0 AND <10.3.255.255, "Insert Subnet Name", if not
Etc for another 30 subnets.
I've made it work for one (obviously pretty easy), but when I had to nest them together it got complex and out of my depth. I have roughly 7000 cells I have to apply this to, and will just be filling the formal down the entire sheet for F3, F4, F5 etc.
Any help would be very appreciated.
TJ
Bookmarks