+ Reply to Thread
Results 1 to 3 of 3

Finding closest with multiple criteria

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    Cph, DK
    MS-Off Ver
    2010
    Posts
    3

    Finding closest with multiple criteria

    Hi

    This is giving me a big headache

    I'm trying to find a number closest to 100 in Column Sheet1!$J$2:$J$131106
    (1st IF) But only in the rows where a certain date (Sheet2!W16) matches in column Sheet1!$C$2:$C$131106
    (2nd IF) and for rows where another certain date (Sheet2!$F$18) matches in column Sheet1!$F$2:$F$131106
    (3rd IF) and for rows where a specific letter - either P/C ($G21) matches in column Sheet1!$H$2:$H$131106

    I have no idea why, but my formula ignores the 2nd if and just takes whatever date it wants from that column but follow through with the two other IFs.

    This is the formula:

    Please Login or Register  to view this content.
    This is the data if needed - https://www.dropbox.com/s/8mxnl2rx6a...e123.xlsx?dl=0

    The formula is used in cell AA16 in sheet 2

  2. #2
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Finding closest with multiple criteria

    Hi,

    Welcome to the forum!

    The file size is more than 43 MB. Try posting a sample file with not more than 100 rows.

    Regards,
    AM

  3. #3
    Registered User
    Join Date
    05-04-2015
    Location
    Cph, DK
    MS-Off Ver
    2010
    Posts
    3

    Re: Finding closest with multiple criteria

    Hi,
    I cut away quite a bit of rows. Its still around 13 MB(!). But it's only around 180 rows. Hope it will do.
    https://www.dropbox.com/s/1fx0oxgf8a...mple.xlsx?dl=0

+ 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] Multiple criteria (finding closest)
    By jram in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-20-2015, 12:02 AM
  2. [SOLVED] Closest match on Multiple Criteria
    By rbetts in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-20-2014, 08:33 AM
  3. [SOLVED] Finding the closest value
    By Hitch75 in forum Excel General
    Replies: 2
    Last Post: 06-09-2012, 01:09 PM
  4. Finding a closest match with more than one criteria
    By Jayana in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-15-2011, 06:45 PM
  5. closest match from multiple criteria
    By wongja in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2010, 01:37 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