+ Reply to Thread
Results 1 to 6 of 6

Lookup next lowest number and return corresponding cell

  1. 05-23-2013, 04:55 PM #1
    R.C.B.
    R.C.B. is offline
    Registered User
    Join Date
    05-23-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    2

    Lookup next lowest number and return corresponding cell

    Please help.

    I have 3 columns of data. I need to lookup column A and find the next lowest number in column B and return the corresponding column C.

    A B C
    4.91 0.65 0.718639673
    11.30 3.2 0.027854251
    26.14 6.95 2.311902822
    27.44 9.65 0.139271254
    34.75 16.25 4.361975687
    44.90 12.2 5.977522237
    68.56 17.25 5.030477708
    83.53 19.85 1.125311735
    98.61 18.35 1.353716592
    Reply With QuoteRegister To Reply
  2. 05-23-2013, 04:58 PM #2
    djapigo
    djapigo is offline
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Lookup next lowest number and return corresponding cell

    Can you give an example? What results do you want to see? Sorry, I'm a little confused...
    Reply With QuoteRegister To Reply
  3. 05-23-2013, 05:02 PM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Lookup next lowest number and return corresponding cell 

    Please Login or Register  to view this content.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  4. 05-23-2013, 05:09 PM #4
    R.C.B.
    R.C.B. is offline
    Registered User
    Join Date
    05-23-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Lookup next lowest number and return corresponding cell

    Sorry, that wasn't clear. I have three rows of data. I would like to look up column A and find the next lowest value in column B. I want to return the value in column C that corresponds to the value in column B. For example, I want to lookup 4.91 in column A, find the next lowest number in B, which is 3.2 and return 0.02785...
    Reply With QuoteRegister To Reply
  5. 05-23-2013, 05:18 PM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Lookup next lowest number and return corresponding cell

    Welcome to the forum
    will this work for you?

    =INDEX($C$2:$C$10,MATCH(A2,$B$2:$B$10,1),1)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  6. 05-23-2013, 05:29 PM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Lookup next lowest number and return corresponding cell

    See the attached file (see the green cells).

    I added helpcolumn while your data in column B is not sorted a- or decending.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1