Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Failed Comparison... why?
Worksheet one....
Cell A1 contains formula: if(B1 = Sheet2!A1), "Yeah!", "Damn!") Cell B1 contains a concatenation of C1 and D1, a model number and serial number (ex. 141565). This number was generate by a macro, so there is no formula in the cell, just the value. Worksheet two is a database export and A1 DOES contain the same value. I have verified there are not any leading or trailing spaces and made sure that the cell format was the same for both...text. But the formula returns false for some reason. If I retype the value generated by the macro and hit enter, then it will return true. If I replace the macro-generated value with a concatenate formula, it also seems to work just fine. But this is not an option for me due to the amount of IF statements needed to correctly pair the model/serial numbers so that they match the values in sheet 2 Any thoughts on what Excel quirk would cause it to see these two values as unequal? Many thanks, S. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
row comparison | Excel Worksheet Functions | |||
Complex comparison of Columns of Data: Extracting unique records after comparison on 4 levels | Excel Programming | |||
comparison | Excel Worksheet Functions | |||
Comparison | Excel Worksheet Functions | |||
Comparison | Excel Programming |