I think your MATCH is working perfectly!!

Here is what I get for the first 10 rows:

1 100 1.0000000 0.01 1
2 50 0.5000000 0.01 #N/A
3 33.33333333 0.3300000 0.01 #N/A
4 25 0.2500000 0.01 #N/A
5 20 0.2000000 0.01 #N/A
6 16.66666667 0.1700000 0.01 #N/A
7 14.28571429 0.1400000 0.01 #N/A
8 12.5 0.1300000 0.01 #N/A
9 11.11111111 0.1100000 0.01 #N/A
10 10 0.1000000 0.01 #N/A

All of column C except C1 is correctly #N/A because, with the exception of
the first row, all the values in column A are greater than 1 and all the
values in column C are less than 1. If match_type is 0, MATCH finds the
first value that is exactly equal to lookup_value. Lookup_array can be in any
order.




Column D is blank and column E has no effect on column F

--
Gary''s Student


"PaulW" wrote:

In column A I have a list of numbers from 1 to 300.
In column B I have =100/A1 dragged down.
In column C I have = ROUND(B1,0)/100

In column E I have numbers starting at 0.01, and increasing by 0.01.
In column F I have =MATCH(A1,$C$1:$C$300,0)

Some of these are errors, I don't have the first clue why.
0.05 gives the answer 19, so on row 19 I can see that, 100/19 is 5.26316, I
can see that this is rounded to 5, then when divided by 100 is now 0.05, and
this if the first instance of 0.05 in column C. Thats perfect.
0.06 gives an error though. But I can see that on row 16, 100/16 = 6.25000,
which when rounded and divided by 100 is now 0.06. There are 3 rows where the
answer is 0.06 (16, 17, 18) but match can't seem to find any of them?
Similarly, I can see that there are errors for 0.10 to 0.16, where I can
clearly see in column C that the numbers 0.14, 0.13, 0.11 and 0.10 are
present.

I tried changing it to a vlookup (although I need it as a match) and the
errors were still aparantly. I've tried changing the match type in the
formula to -1, this give me an answer for each one, but quite often the wrong
answer...

I've done a formula of =E6=C16 to see if both 0.06's are the same, and it
returns as TRUE, so why can't MATCH find it?