Results 1 to 6 of 6

Trouble looking up a text and bringing back something if a value is >= a specific date

Threaded View

  1. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Trouble looking up a text and bringing back something if a value is >= a specific date

    In K10, copied down:
    =IFERROR(INDEX($A$10:$A$17,MATCH(0,INDEX(COUNTIF($K$9:$K9,$A$10:$A$17),0),0)),"")

    In J10, copied down:
    =IF(SUMPRODUCT(($A$10:$A$17=K10)*($C$10:$C$17>=$C$7))>0,1,"")
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countif bringing back Value Error.
    By Cbirchfi in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-06-2016, 01:09 PM
  2. Indexing bringing back value of row below the one it should?
    By jonnegri in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-26-2014, 04:26 PM
  3. Replies: 4
    Last Post: 05-07-2014, 11:20 AM
  4. [SOLVED] VBA not bringing back the correct date
    By jonathan.haynes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2013, 06:55 AM
  5. [SOLVED] Stop Vlookup bringing back 0's or #REF! and bring back blanks instead
    By Carling73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 04:43 PM
  6. [SOLVED] Excel 2007 : Bringing Back the final date/time combo of multiple calls
    By Icehockey44 in forum Excel General
    Replies: 9
    Last Post: 05-24-2012, 05:27 AM
  7. Excel 2007 : Lookup - bringing back more than one value
    By csalcido in forum Excel General
    Replies: 2
    Last Post: 04-23-2012, 01:59 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