I've been scouring the internet to find addins or macros that are built to do manipulation or lookup of IP addresses and ranges. Essentially, this is what I'm trying to do....

I have a file where column A is a business location. Column B is the first subnet range in use at that location in the format 192.168.1.0-192.168.1.100

Column C and thereafter are structured exactly like B until all ranges at that location are defined. Any location may have one or more subnet ranges.

So how can I parse this out or do some kind of lookup so that if I have an IP address (e.g., 192.168.1.23), it returns the location in column A.

Thanks,
Bob