So I have attached a screen shot, of a basic example of what i'm trying to accomplish.
Simply put, If want to have a certain cell "Device IP" as its listed in my table, have a certain IP address entered in to it. I want the IP in that cell to be looked up to see if it matches a range.
IE 192.168.1.0-192.168.1.254, which I have in Cell A2 "192.168.1.0" and in Cell A3 I have "192.168.1.254". In Cell A4 I have a location. If the IP that was entered matches in that range the location will show up in the "Location" tab.
Please let me know if you need any further clarification.
Using Excel 2010 x86.
excel help.png
Bookmarks