+ Reply to Thread
Results 1 to 5 of 5

Search postal in a certain range

  1. #1
    Registered User
    Join Date
    03-08-2017
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2013, 2016
    Posts
    42

    Search postal in a certain range

    Dear readers,

    I need some help with this spreadsheet. I have a sheet with delivery orders. Based on country and postal I need to add a postal zone with
    a search function. I've experimented with IF and VLookup, but no success for now.

    I've added a spreadsheet that contains an example of the problem. Hopefully you guys can help me out on this one.
    I'm confinced it isn't a big problem. I just think i can't get the formula right.

    Thanks in advance!
    Attached Files Attached Files
    Last edited by gromtouwe; 06-08-2018 at 09:39 AM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Search postal in a certain range

    xls is an old file format from Excel 2003. Your profile show Excel 2013 so ... update profile or change the file format to xlsx, please?

  3. #3
    Registered User
    Join Date
    03-08-2017
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2013, 2016
    Posts
    42

    Re: Search postal in a certain range

    I'm sorry. I've uploaded the xlsx now.

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Search postal in a certain range

    Try:

    =INDEX($D$15:$D$40,MATCH(1,INDEX(($A$15:$A$40=C4)*($C$15:$C$40-E4>=0),0),0))
    Last edited by Phuocam; 06-08-2018 at 09:44 AM.

  5. #5
    Registered User
    Join Date
    03-08-2017
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2013, 2016
    Posts
    42

    Re: Search postal in a certain range

    It worked. Thank 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. Replies: 16
    Last Post: 07-11-2017, 04:22 PM
  2. Postal Code range lookup
    By yaman in forum Excel General
    Replies: 2
    Last Post: 02-06-2017, 02:11 PM
  3. Postal Paper Work
    By Randy Putman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-08-2016, 04:44 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
  6. Postal formula
    By omutumo in forum Excel General
    Replies: 2
    Last Post: 05-22-2006, 06:20 PM
  7. [SOLVED] Validation of Postal Code
    By Veronika in forum Excel General
    Replies: 1
    Last Post: 12-16-2005, 05:45 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