+ Reply to Thread
Results 1 to 3 of 3

Find address and return GPS location from another sheet

  1. #1
    Registered User
    Join Date
    08-08-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Find address and return GPS location from another sheet

    I have a table with customers and their addresses (sheet2) and I need to find their GPS locations in sheet1.

    I guess the logic would need to be something like this:


    find CityName and StreetName in sheet1 where StreetNo is between minStreetNo and maxStreetNo
    return GPS X and GPS Y


    Can someone please help me with the formula or VBA code?

    Thank you very much!

    Example.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Find address and return GPS location from another sheet

    Please Login or Register  to view this content.
    AND

    Please Login or Register  to view this content.
    Array formula so ctrl shift and enter.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    08-08-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Find address and return GPS location from another sheet

    Quote Originally Posted by nathansav View Post
    Please Login or Register  to view this content.
    AND

    Please Login or Register  to view this content.
    Array formula so ctrl shift and enter.
    These formulas are great, but when I apply them to 1000+ or even 100+ customer addresses and GPS coordinates, I get this error:

    "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IP address lookup - return city location
    By rtcwlomax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2013, 02:15 PM
  2. [SOLVED] Find lowest value in corresponding cells on multiple worksheets. Return value & location.
    By WORKINGBEE in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-21-2013, 01:33 PM
  3. Replies: 2
    Last Post: 02-19-2013, 06:48 PM
  4. [SOLVED] Macro to find filename from list in excel and return its location
    By puppythor in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 02-03-2013, 02:17 AM
  5. Replies: 1
    Last Post: 06-24-2010, 09:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1