+ Reply to Thread
Results 1 to 3 of 3

LIST of postal codes then cell to say east or west? to help sort list geographically

  1. #1
    Registered User
    Join Date
    03-16-2014
    Location
    hawaii
    MS-Off Ver
    Excel 2003
    Posts
    2

    LIST of postal codes then cell to say east or west? to help sort list geographically

    any help would be appreciated.

    if i have a list of postal codes example below....what formula would i use that would need to match the code exactly then input text next to cell to say east or west so I can geographically sort a list of people? any help for a formula or attached sample spread sheet?
    L9H WEST
    L9G WEST
    L9K WEST
    L8S WEST
    L9C WEST
    L8P WEST
    L9B WEST
    L8R west



    L8N EAST
    L9A EAST
    L8W EAST
    L8V EAST
    L8M EAST
    L8L EAST
    L8T EAST
    L8K EAST
    L8H EAST
    L8G EAST
    L8J EAST
    L8E EAST

  2. #2
    Registered User
    Join Date
    02-09-2014
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    84

    Re: LIST of postal codes then cell to say east or west? to help sort list geographically

    L9G WEST =VLOOKUP(A2,$A$7:$B$29,2,0)
    L8W EAST =VLOOKUP(A3,$A$7:$B$29,2,0)

    maybe this helps?

    L9H WEST
    L9G WEST
    L9K WEST
    L8S WEST
    L9C WEST
    L8P WEST
    L9B WEST
    L8R west



    L8N EAST
    L9A EAST
    L8W EAST
    L8V EAST
    L8M EAST
    L8L EAST
    L8T EAST
    L8K EAST
    L8H EAST
    L8G EAST
    L8J EAST
    L8E EAST

  3. #3
    Registered User
    Join Date
    03-16-2014
    Location
    hawaii
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: LIST of postal codes then cell to say east or west? to help sort list geographically

    thanks i found this =VLOOKUP(LEFT(K5,3),'postal list'!$A$2:$B$51,2,FALSE) basically took the first three letters of list i created.... thanks for the help as wel

+ 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. Distance between Canadian Postal Codes
    By lesleyhollett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-17-2013, 10:47 AM
  2. [SOLVED] Format for Canadian Postal Codes
    By rmcc in forum Excel General
    Replies: 25
    Last Post: 07-24-2012, 02:04 PM
  3. Replies: 7
    Last Post: 05-05-2011, 04:25 PM
  4. IF and OR help for postal codes
    By Richard Bunt in forum Excel General
    Replies: 1
    Last Post: 10-09-2009, 06:30 AM
  5. [SOLVED] Distances between Postal Codes
    By Irfan in forum Excel General
    Replies: 1
    Last Post: 05-31-2006, 05:55 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