+ Reply to Thread
Results 1 to 2 of 2

Index Match with ABS and Inequality

  1. #1
    Registered User
    Join Date
    06-23-2015
    Location
    Austin
    MS-Off Ver
    MAC 2011
    Posts
    18

    Index Match with ABS and Inequality

    Hi,

    Spreadsheet attached for reference. I'm looking for a formula that does the following:
    -Looks through a column of numbers, and return the next value in the column that meets a criteria
    -The criteria being that the absolute value of the next number is less than a fixed value being referenced
    -And then returns the value in a different column, but same row.

    In the attached spreadsheet, the needed formula is in Column Y. The formula is supposed to look at the values in Column M, starting on the next row after the formula in Column Y, and find the next value in Column M with an absolute value less than the reference cell, C2. I would like the formula to then return the value in Column A that is on the same row as the matched value from Column M.

    For example from my spreadsheet, the value in Y10 should be returning the number "4" but instead I'm getting an #NA.

    I know this explanation seems confusing. I'm trying to do this with and Index Match, but am struggling. Any suggestions?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,918

    Re: Index Match with ABS and Inequality

    m8:
    Please Login or Register  to view this content.
    y8 (array):
    Please Login or Register  to view this content.
    Ben Van Johnson

+ 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] Using INDEX and MATCH with an inequality
    By CDN in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-04-2019, 03:49 PM
  2. Use of inequality criteria in INDEX function
    By lmyers95 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2017, 06:13 PM
  3. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  4. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  5. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  6. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  7. Replies: 3
    Last Post: 05-02-2013, 01:31 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