LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 130
Default Match doesn't work all the time?

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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you subtract time as in a timecard to calculate hours work Dave Davis Excel Worksheet Functions 2 September 18th 06 05:58 PM
synchronizing timestamp feature with time on video software. 999 Excel Discussion (Misc queries) 4 July 30th 06 10:49 PM
time sheet Jesse_Norris Excel Discussion (Misc queries) 4 September 8th 05 04:43 AM
time math USAOz Excel Worksheet Functions 2 August 14th 05 07:19 AM
How can i work a formula for time limit? Roze Excel Worksheet Functions 2 November 25th 04 02:41 PM


All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"