I'm trying to find a formula to search IP addresses for their country of origin.
If someone has a list of countries to do a vlookup based on the IP data or if someone has a formula to check the IP addresses against a website and return them in the spreadsheet that would be very helpful.
Thank you for any help you can give.
1st step here is to get a list of IP's per country - perhaps get that using a google search? Although I have a feeling that will be a HUGE list.
This turned up some potential links...
https://www.google.com/webhp?sourcei...0per%20country
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for the response, I managed to find a good lookup template for this problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks