Results 1 to 5 of 5

Index match with two criteria, one closest value and one specific

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    ljubljana
    MS-Off Ver
    excel 2010
    Posts
    3

    Index match with two criteria, one closest value and one specific

    Hi,

    I have a problem with using index match function where one criteria will always be exact match and exact or closest value.

    Capture.PNG

    I want a function which returns me the value closest to zero (or zero in some cases) for every hour in a day (there is always a different number of rows for each hour). I have been trying with the index match function where one match criteria was for the closest value (number closest to zero) and other for finding the specific hour. The problem is, if I select the whole column of number and use MIN(ABS(column-0) for the match function, that value is always zero (because at least one hour has some value zero). And if other hours don't have the zeros in some rows, I get NA.. I need to define matching value for each hour separately somehow.. I hope you understand the problem. Attached is also an example in excel.

    Regards,
    Rok
    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. Index closest match
    By MJSlattery in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-16-2013, 10:27 PM
  2. [SOLVED] Index-Match Closest Value
    By CzechCzar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2013, 07:40 PM
  3. Replies: 2
    Last Post: 09-25-2013, 07:18 PM
  4. Match the Upper closest value using Index Match.
    By adnanaddo in forum Excel General
    Replies: 3
    Last Post: 01-16-2013, 02:47 AM
  5. Index/Match Formulas - Search/Filter Based on Specific Criteria
    By Christopher.Belanger in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-10-2012, 08:42 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1