Excel EXACT
1 Topic
Data looks to be the same, but EXACT function says it's not - how to I find out why?
I've got two text strings that to the eye appear to be the same. Even an IF function comparing the two says they are the same. However, when I use the EXACT function it says they are not. The reason I got into this is I was actually comparing data in two sheets and getting values using a combo of INDEX & MATCH functions. I hit some rows that didn't return data. I looked a the instances where it didn't work and I got a #N/A and to the eye they appear to be the same. I then copied one of the instances to another sheet and just tried to figure out why. My first check was with a simple IF statement and it takes the true path. =IF(B1=B2,"ok","NO") I then did a simple EXACT and it gave me FALSE =EXACT(B1,B2) I even tried a CLEAN of each one first and still got FALSE =EXACT(CLEAN(B1),CLEAN(B2)) This is driving me crazy. Any help will be greatly appreciated.Solved19KViews0likes4Comments