+ Reply to Thread
Results 1 to 3 of 3

Finding first value that is greater than value

  1. #1
    Registered User
    Join Date
    07-25-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    6

    Finding first value that is greater than value

    I am trying to use VLOOKUP to return a value only if it greater than
    or equal to a value on current sheet. Here is what I have:

    =IF(ISNA(VLOOKUP($A3,’sold 1’!C$2:F$1201,4,FALSE))>=(D3+24),
    (VLOOKUP($A3,'sold 1'!C$2:F$1201,4,FALSE)))

    Currently it only pulls the first value it finds in column 4 of the
    table array that matches the lookup value but I want it to return the
    first value it finds in column 4 that matches the lookup value that is
    greater than or equal to cell D3+24.

  2. #2
    Registered User
    Join Date
    09-22-2009
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2010 (Work) O365Home (Home)
    Posts
    94

    Re: Finding first value that is greater than value

    need an example speardsheet to better understand

  3. #3
    Registered User
    Join Date
    07-25-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Finding first value that is greater than value

    I am trying to populate column L with the first date for that record # that occurs >= 24 days after column C thats on the tab sold 1.
    Attached Files Attached Files

+ 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