+ Reply to Thread
Results 1 to 5 of 5

Formula to Find Zone for range of Zip codes Thank you!

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    California
    MS-Off Ver
    Pro 2010
    Posts
    2

    Formula to Find Zone for range of Zip codes Thank you!

    Hello,

    I have set up what I can so far, I just need help with a formula. please see attachments of what I have so far,Capture1.JPG Capture2.JPG. I need to be able to find the Zone certain zip codes are in based on the range on the 2nd sheet. Please let me know if there is any more information needed or if I need to show more of the sheet for reference.
    Last edited by businessdevelopment; 11-25-2014 at 05:00 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Need formula to Find Zone for range of Zip codes (Help ASAP) Thank you!

    Okay, I assume that the picture on the left is sheet1 and on the right is sheet2
    I see you broke up Col A in C and D (that's good)
    I don't know where you are looking to put a formula and how sheet 2 relates to sheet1.
    Are those numbers in C and D, the last 3 digits of the ZIP?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Need formula to Find Zone for range of Zip codes (Help ASAP) Thank you!

    Warning Removed..
    Last edited by Debraj Roy; 11-25-2014 at 05:01 PM.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  4. #4
    Registered User
    Join Date
    11-25-2014
    Location
    California
    MS-Off Ver
    Pro 2010
    Posts
    2

    Re: Need formula to Find Zone for range of Zip codes (Help ASAP) Thank you!

    Ok I switch the attachments so you can see it as I see it (Sheet 1 and Sheet 2). I have another column for Zone codes that would be the I column on Sheet 1.

    C and D are the first three numbers of the Zip code

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Formula to Find Zone for range of Zip codes Thank you!

    Okay so assuming you want to pull the zone over for column I, in I2

    =INDEX(sheet2!$B$1:$B$20, MATCH(H2, sheet2!$C$1:$C$20))
    Does that work for you?

+ 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. [SOLVED] Find all entries in a range and tally numbers based on codes in adjacent fields
    By reynastus2 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-07-2014, 10:28 PM
  2. Replies: 0
    Last Post: 10-09-2013, 07:59 PM
  3. Macro or formula to find code and print codes
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-17-2012, 08:34 AM
  4. Replies: 1
    Last Post: 03-08-2011, 11:51 AM
  5. sorting by time zone based on zip codes
    By rooshio in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2009, 07:57 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