Formula in Cell causing my comparitor code to give false results

[Minksta]

I am having trouble getting my code to run properly. I am pulling in values from another sheet into column A & B via =IF(Repair!B57<>"",Repair!B57,""). I have the below code that runs, which compares the values in columns A & B to columns D & E and if it finds a match outputs on that line that it found a match. I am comparing 5 records and the first 4 work properly, but on the 5th it doesn't. The problem is, for the last record it is not showing me the correct results. If I go in and type the actual value in the cell in column B rather than the formula, it works. Any help is greatly appreciated!

Code:

Please Login or Register  to view this content.

[MrShorty]

It can be difficult to debug this sort of thing with the code only. As near as I can quickly tell, the code is syntactically correct. From what you describe, it sounds like it is a problem with the actual values (which we cannot see). My first guess is that the displayed value is rounded (or otherwise different) from the actual value stored in the cells. These rounding errors cause tests like "is A exactly equal to B" to fail. I think you will need to look at the values you are comparing and check to see if they are "exactly equal" or not, and adjust your comparison accordingly.

[Minksta]

Thank you MrShorty for reviewing my code. I have my file uploaded to the below link if you have the time to review this. I commented out the code the populates columns D and E so when you click the button you will see the issue. Thanks again!!

http://www.filedropper.com/comparisonhelp