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?
Bookmarks