I am trying to write a formula that will match IP Addresses to a range which will name an office location. The problem I am having is not all the ranges are the same.

Below is an example. Column A is the information I will have. Column B is the location I want it to return. Column C is my notes explaining what it should match. Columns F and G is how it should match.

I have been all over many forums and can't find a way to match this as I would need it due to the IP range differing each time. Any assistance would be GREATLY appreciated!!! Thanks in advance for your time.

I tried to attach an actual excel but the attach button doesn't bring up a window no matter what browser I tried to use.

Capture.JPG