View Full Version : IP address manipulation and lookup in a spreadsheet

01-12-2010, 02:49 PM
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

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.,, it returns the location in column A.