I am using Excel 2002 and trying to do something which should be simple with MATCH.

I have an array of numbers ordered, starting at 0 and incrementing by 0.05 up to 20. I am then using the MATCH function to find the relative position of numbers 0,1,2,3,4 and 5. However, for number 0,1 and 2 the return value is one less than what it should be, for the numbers 3, 4 and 5 it is working as expected. By the way, the match_type I am using is the default 1.

Also I have formatted everything to be numbers and tried various things already, so am beginning to wonder is this is a known issue. I really hope not.