Morning all,
This is a longshot and not sure if it is even possible but I am trying to populate the post code along with longitude & latitude for an address. I have attached a test spreadsheet and ideally need formulas for the columns [Post Code] [Longitude] [Latitude] to lookup on the internet and populate the information. The main spreadsheet contains about 100,000 entries so doing this 1-by-1 is an impossibility.
Fingers crossed there is a genius that can help!
Last edited by StewS73; 06-02-2022 at 04:19 AM.
Where on the internet would you look this up?
It seems that Doogal is a good place to get the information https://www.doogal.co.uk/ShowMap.php...ode=TN34%203EY
I think getting the postal code from an address will be the challenge here, but there is an article here that talks about achieving the rest: https://www.adventuresincre.com/auto...ngitude-excel/
I am really not sure that the first bit can be done.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks Ali, that seems like a good place for me to start. I'll mark this as resolved for the time being and see if one coordinates are in I can then look at something to get a post cade.
OK - glad to have helped (a bit).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks