juster21 said:this is my formula...
=if(C1=SHEET2!B1,SHEET2!A1,"NOT EQUAL")
This works fine until row 121.....can't figure out why. The values are equal.
juster21 said:Interesting!! My C value has a space before the first number but I can't see that space. If I click in the formula bar and backspace, the number doesn't move but the formula does work. Any way to fix this on a BIG scale?