+ Reply to Thread
Results 1 to 4 of 4

Value return from Minimum and Maximum values

  1. #1
    Registered User
    Join Date
    05-17-2007
    Posts
    69

    Value return from Minimum and Maximum values

    Hi all,

    I have a file where I have the maximum and minimum values of Zipcodes. I need to get the state from that tab into another file where the codes are listed but the state has a null value. I have attached a file with 2 tabs. One tab is the zip code tab which lists all the max and min value of the zipcodes and the state. I want a formula that will look up these codes and insert the state in the States tab.

    Thanks in advance.

    Indira
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-29-2009
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    123

    Re: Value return from Minimum and Maximum values

    Try an index-match array formula. See attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-17-2007
    Posts
    69

    Re: Value return from Minimum and Maximum values

    Thanks so much! That works perfectly!

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Value return from Minimum and Maximum values

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] Multiplication & divide with a minimum & maximum return
    By allend5 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2013, 08:29 AM
  2. [SOLVED] Conditional maximum and minimum values
    By metsci in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-20-2013, 11:35 PM
  3. pulling out minimum and maximum values..!
    By via135 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-04-2011, 11:05 AM
  4. Replies: 4
    Last Post: 09-18-2009, 02:09 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