I have a google sheet DB of 15000+ locations (suburbs, state and postcode) that are classified in zones, our nearest service location and the distance in KM between our nearest service location and suburb.
I need the sheet to be automated so that when a random address is entered as input it checks the string and matches it with the DB and relevant results are shown.
The input address can vary, sometimes it may be just the suburb and post code, sometimes it will be the whole address with street Address or sometimes it may be just state and post code.
The DB which is in google sheets have suburb in one cell , state in another and post code in the third cell. Each of these are classified into remote, regional and metro. Each site will have the nearest service location and the associated KM between the service centre and the suburb.
Attached is the DB screenshot. Column named “POP” is the nearest service centre for the suburb.
Hi, Greetings!
✅ I have checked and gone through the project details and I am very skilled in it.
✅Completed Time: In project deadline
We have worked on 640 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly.
My Portfolio Items: https://www.freelancer.com/u/schoudhary1553
I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion..
Thank you
Sandeep
Digital screencast