I am using match with match type 1 with an unordered list. I know you are supposed to order it, but I cannot. It seems like excel is looking for a portion of the lookup range that is in order and giving a value that is the largest value less than the lookup value inside that portion of the...