Im trying to create a lookup function that produces the date(column B) of when a certain value is under 10000 (column A). Column A is not in
ascending order. I have tried lookup functions, as well as index(match) function, but because I am not searching for an exact match, they have not worked. Any advice?
Bookmarks