Get a location from an IP Address range

[arcsum68]

Hey all,

Definitely not a pro, but I usually can fumble my way through Excel well enough, but alas I need some help.

I am loosing a tool that did this for me, but what I need to do is resolve a location based on an ip from a table of ranges and locations. I extracted our DNS tables from Active Directory and am now trying to figure out how to make this work, but I suspect that the fact that IP's are in octets its screwing up any regular formulas, just not sure how to properly break them up or change them. I have tried a ranged vlookup, but it wont capture most of the IP's. If this has already been answered somewhere, feel free to point me in that direction as I am not finding it. I have attached a sample file, but basically here's what I need to lookup.

Column A Column B Column C Column D Column E Column F
Beginning IP Ending IP Location IP Location Lookup
192.168.0.1 192.168.0.255 Location A 192.168.0.1 Need answer here
201.202.0.0 201.202.0.255 Location B 192.168.0.20 Need answer here
192.168.0.200 Need answer here
201.202.0.75 Need answer here
201.202.0.245 Need answer here


I have Office Pro Plus 2016 and Kutools 16 installed

Thanks all