+ Reply to Thread
Results 1 to 4 of 4

Assignment of number depending on range it falls into

  1. #1
    Registered User
    Join Date
    07-16-2009
    Location
    nebraska
    MS-Off Ver
    Excel 2007
    Posts
    2

    Assignment of number depending on range it falls into

    Hello - I have something I cannot figure out. I would appreciate any help you can give... A spreadsheet is attached.

    The number in cell M21 falls into one of the ranges from C4 to C15.
    A matrix number needs to be printed in each cell from N21 to N30.
    The selection of the number to be printed in column N (under Matrix Assignment) depends on the range it is next to in array A4:C15.

    For example (as shown), the correct number for cell N21 is 122 because 0.2626 falls between 0.24 - 0.2699, and Matrix 122 corresponds to that range.

    Hopefully I explained this so you can understand what I really need. Thanks.
    Attached Files Attached Files
    Last edited by joeschmo; 07-16-2009 at 11:31 AM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Assignment of number depending on range it falls into

    If you type your lower boundaries (0.12, 0.15, 0.18 etc) into, e.g B4:B15 then this formula in N21 and down should work:

    =INDEX($A$4:$A$15,MATCH(M21,$B$4:$B$15),1)

  3. #3
    Registered User
    Join Date
    07-16-2009
    Location
    nebraska
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Assignment of number depending on range it falls into

    Thank you, Stephen R.
    Joeschmo believes you to be a steely eyed excel man!

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Assignment of number depending on range it falls into

    Ha ha, that's one of the best compliments I've had. How sad is that?

+ Reply to Thread

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