Cells with same text but excel think it's different?

J

Jason

I have two cells with exacely the same text. but excel think it's different and not returning any value for my vlookup.. I used if statement and the result is showing the 2 cells are different.
I checked format, space and even '.
can someone please help?
thanks.
 
A

Andy Wiggins

Do you have an 0 instead of a O? (Number zero, letter O)

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



Jason said:
I have two cells with exacely the same text. but excel think it's
Click to expand...
different and not returning any value for my vlookup.. I used if statement
and the result is showing the 2 cells are different.
 
E

Earl Kiosterud

Jason,

Try = Len() on each. And there may be code 160 characters for spaces,
instead of the usual code 32.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Jason said:
I have two cells with exacely the same text. but excel think it's
Click to expand...
different and not returning any value for my vlookup.. I used if statement
and the result is showing the 2 cells are different.
 
D

Debra Dalgleish

One way to compare the cells:

Enter a number in a cell (cell D1 in this example) --
use a number that's about 1/2 the number of characters in the cell
Type a formula to compare the characters from the left of the two cells
(cells A2 and B2 in this example)

=LEFT(A2,$D$1)=LEFT(B2,$D$1)

If the result is TRUE, increase the number until it returns FALSE
If the result is FALSE, decrease the number until it returns TRUE.
That will tell you where the strings differ.
 
Top