I am using the Index/Match function to find a value in an array and I am not sure why the match
function is returning the wrong value. The data is as follows:

Search array:

A1 = 0
B1= 9999
C1= 0
D1= 0
E1= 0


Formula using: Match(221,A1:E1,1)

Based on what I read on how the match function is to work, the match type of 1 would find the
largest value that matches the lookup value exactly or less than. Thus, it seems to me that
the formula I have above should return the value of "1" because 221 is less than 9999. But, it
is returning the value "5". Why is that?