Results 1 to 5 of 5

Using to and from zip codes to locate a single sheet

Threaded View

  1. #1
    Registered User
    Join Date
    09-02-2008
    Location
    St Louis
    Posts
    5

    Using to and from zip codes to locate a single sheet

    Greetings.

    Hopefully, someone will have an elegant solution to this.

    I have a large spreadsheet with multiple tabs. Each tab corresponds from a shipping area, like Chicago, to another area, like Saint Louis. We ship from and to most, but not all, zip codes in a given metropolitan area.

    Currently, the first sheet has hyperlinks to all of the from/to combinations, but the user has to know where to go and it's easy to make a mistake for a new user. What I would like to do is give the user a chance to put the From and To zips in two different cells and then do some sort of operation that will look at the first three numbers in both zips, then link to the right from/to sheet.

    Off the top of my head, I guess it could be done through a laborious vlookup of a table of hyperlinks combined with nested IF statements, but that seems like the sledgehammer approach.

    Any thoughts?
    Last edited by scottmcglasson; 09-02-2008 at 09:31 AM.

Thread Information

Users Browsing this Thread

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

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