IP address manipulation and lookup in a spreadsheet

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