+ Reply to Thread
Results 1 to 3 of 3

Equal or higher numbers selection function display

  1. #1
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Question Equal or higher numbers selection function display

    Reference to the my following thread link:
    http://www.excelforum.com/excel-form...html?p=3361841

    Attach is a the new file with the new column.

    I need help please with formulas in cells E1, F1 and G1 in order to achieve the following result:
    When manually inserting a number in cell D1, I would like please the formulas to display in cells F1 and G1 respectively the two matching equal or higher numbers than cell D1 number from the same row, and a formula in cell E1 cell display the temp value in column A for the same resulting row of the E1 and G1.

    Example:
    If I entered the number 3355 in cell D1, I would like the formulas in cells E1, F1 and G1 to display the following result:
    Cell E1 (24), F1 (3525), G1 (3400) respectively.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Equal or higher numbers selection function display

    hi Khaldon, try this in E1:
    =LOOKUP(2,1/(($B$2:$B$7>=$D1)*($C$2:$C$7>=$D1)),A$2:A$7)

    copy across

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Re: Equal or higher numbers selection function display

    Thank you,
    Last edited by Khaldon; 08-16-2013 at 07:29 AM.

+ 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] Help please with Look function of equal or higher value
    By Khaldon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2013, 02:26 PM
  2. Need to Display last 3 numbers from selection of 10 cells - without zeroes
    By simmo6477 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2013, 09:48 AM
  3. [SOLVED] Comparing columns for values higher, lower, or equal...
    By D.Lovell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-18-2013, 07:22 PM
  4. [SOLVED] Display the value of a row with the higher corresponding bottom value
    By temptemp9 in forum Excel General
    Replies: 3
    Last Post: 11-18-2012, 07:53 AM
  5. Replies: 3
    Last Post: 12-20-2011, 07:13 AM

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