Hi All,
I have a column of IP addresses and would like to fill in the next column with the city relative to that IP address.
I have found some code online but no idea how to implement it. If anybody can supply a simple function that I can paste into the blank cell and it returns the city it would be much appreciated.
This is what I have found but far to complicated for me as dont know how to use it. http://jayteknews.blogspot.co.uk/201...-nslookup.html
Bookmarks