I have a array of numbers that I cannot sort in which I need to find a value
that is the next smallest (or exact) to the value I am looking for. Then I
want to return a corresponding value in another column, but in the same row.

I found if the numbers occurs twice, the LOOKUP commnad will yield the 2nd
incident of this number. The INDEX MATCH command will work, but only if the
number is an exact match, else same problems as lookup.